Skip to content

Registered aircraft · 4,469

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:94-20-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-20-04-R2') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:94-20-04-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-20-04-R2')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:94-20-04-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-20-04-R2')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N9530YWynen Nick J Trustee · Ankeny, IABuilt 1962 · S/N D-7019 N9531RLance Roger K · Monument, COBuilt 1959 · S/N D-6085 N9531YWhite Bill E · Estacada, ORS/N D-7020 N9532RFauchier Janice E · Huntington Beach, CAS/N D-6089 N9533RCreacy Jason T · Gatesville, TXBuilt 1959 · S/N D-6095 N9537RMagnoni Gerald A · Olympia, WABuilt 1959 · S/N D-6093 N9538RRatley Lon O · Langtry, TXBuilt 1959 · S/N D-6094 N953TDavis Richard H Jr · Tulsa, OKBuilt 1961 · S/N D-6650 N9540RGorman Jeffry S · Portland, ORBuilt 1959 · S/N D-6103 N9545YFoster John Brady · Murfreesboro, TNBuilt 1962 · S/N D-7084 N9546YVercouteren Peter J · Fond Du Lac, WIBuilt 1962 · S/N D-7026 N9547RBroussard Richard F · Kent, WABuilt 1959 · S/N D-6143 N9548RCherry Hill Aviation Inc · Freetown, INBuilt 1959 · S/N D-6110 N9549RMair David N · Keller, TXBuilt 1959 · S/N D-6100 N954DRLulafay LLC · Lewes, DES/N D-6141 N9550REngland Steven B · Dublin, OHBuilt 1959 · S/N D-6108 N9551RDunn Agri & Aviation LLC · Kalispell, MTBuilt 1959 · S/N D-6109 N9551YPinney Sidney G · Ocala, FLBuilt 1962 · S/N D-7028 N9552YBanfe Kathy Kieran Hinds · Johns Island, SCBuilt 1962 · S/N D-7053 N9553QTaylor Matt · Tahoka, TXBuilt 1966 · S/N D-8189 N9553RAnderson James W · Kennebec, SDBuilt 1959 · S/N D-6104 N9555QRegistration Pending · Cottonwood, AZRegistration pendingBuilt 1966 · S/N D-8193 N9557YMckinnon Wayne · Douglas, GABuilt 1962 · S/N D-7030 N955QBuy Fly Sell LLC · Inverness, FLBuilt 1962 · S/N D-6835 N9560RMacclements Jonathan E · Austin, TXBuilt 1959 · S/N D-6126 N9561QOliver James L · Orion, MIBuilt 1966 · S/N D-8171 N9561RPaul David A · Hot Springs, ARBuilt 1959 · S/N D-6127 N9562RWashburn Tom · Terrell, TXBuilt 1959 · S/N D-6128 N9564REl Avion Del Abuelo LLC · Ashburn, VABuilt 1959 · S/N D-6119 N9565QBonanza II LLC · Milton, FLBuilt 1966 · S/N D-8282 N9565RLawton Stephen A · Hillsboro, TNBuilt 1959 · S/N D-6115 N9566QMoskol Jake · Madison, WIBuilt 1966 · S/N D-8201 N9566YBell Charles Jay · Salina, KSBuilt 1962 · S/N D-7041 N9567QDreger Jeffrey W · Poplar Grove, ILBuilt 1966 · S/N D-8202 N9567RBentivogio Mariano · Hampton, GAS/N D-6137 N9568QN9568q LLC · Lake Worth, FLBuilt 1966 · S/N D-8203 N956VParker Aerospace LLC · Warren, VTBuilt 1975 · S/N D-9817 N9570RFedorowicz Walter P · Aurora, COBuilt 1959 · S/N D-6133 N9572RThompson Charles R · Maysville, KYBuilt 1959 · S/N D-6164 N9574QHarris Steven L Trustee · Sisters, ORBuilt 1966 · S/N D-8205 N9574RBoykin Bobby · Brandon, MSS/N D-6166 N9575RGotsdiner Alexander M · Panama City Beach, FLBuilt 1959 · S/N D-6170 N9576RBuechle Mark T · Marshall, MIBuilt 1959 · S/N D-6171 N9577RLawrie Daniel A · Mesa, AZBuilt 1959 · S/N D-6144 N9578RJudd Richard M · Austin, TXS/N D-6174 N9578YWitte Mark E · De Witt, IABuilt 1962 · S/N D-7042 N9579RSotax Inc · Tacoma, WABuilt 1959 · S/N D-6176 N9580RHershberger Daniel S · Bedford, INBuilt 1959 · S/N D-6178 N9582RP F M Aviation Inc · Toledo, OHBuilt 1959 · S/N D-6138 N9583QHangarfinds LLC · Westminster, COBuilt 1966 · S/N D-8211

Back to AD 94-20-04 R2