Skip to content

Registered aircraft · 54,015

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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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.

N67859Guerra Gerald T · Sandusky, OHBuilt 1978 · S/N 15282063 N6785MRocerick Dean G · The Dalles, ORBuilt 1975 · S/N 18263834 N6785RRood Enterprises LLC · Livingston, TXBuilt 1966 · S/N T210-0185 N6785SSchmidt Gary C · Sunrise Beach, MOBuilt 1967 · S/N 15067585 N67864Amoth Travis M · Princeton, CABuilt 1978 · S/N 15282068 N67865Laurel Highlands Aeronautical Academy · Latrobe, PABuilt 1978 · S/N 15282069 N6786ARutledge Brett B · Yuma, COS/N 28886 N6786FBeitz Norman Roy · Quitman, TXS/N 15063386 N6787HGordon Caleb J · Waukesha, WIBuilt 1975 · S/N 17265582 N6787RJensen Leland · Idaho Falls, IDBuilt 1966 · S/N T210-0187 N67888Flight Directors LLC · Fifield, WIBuilt 1978 · S/N 15282077 N6788MEs Limited · Edmond, OKS/N 18263836 N6789AChris Fuher Flight Instruction LLC DBA · Townsend, MTS/N 28889 N6789EHeinen Avionics LLC · Adrian, MIBuilt 1959 · S/N 56289 N6789KDrc Equipment LLC · Caldwell, IDBuilt 1976 · S/N 182-65066 N6789MPlane Services LLC · Twin Falls, IDBuilt 1975 · S/N 18263837 N6789RDodson International Parts Inc · Rantoul, KSBuilt 1966 · S/N T210-0189 N678CTSanborn Thomas W · College Station, TXBuilt 1978 · S/N P21000019 N678GHHamilton Gilbert R · Leesburg, VABuilt 1977 · S/N 177RG1283 N678JBSierra Flyers Inc · Incline Village, NVBuilt 1980 · S/N 18267541 N678KPalm Steven · Madera, CABuilt 1956 · S/N 29454 N678KSKingsky Flight Academy LLC · Lakeland, FLBuilt 1978 · S/N 15281673 N678RMLaw Roger Jay · Franklin, INBuilt 1961 · S/N 17248390 N678WLanghoff John A · Yoakum, TXBuilt 1969 · S/N 18259757 N67904Mirza Wajahat · College Station, TXBuilt 1978 · S/N 15282089 N6790ALaurel 406 Aero · Billings, MTS/N 28890 N6790GMartin Christopher G · Monessen, PABuilt 1970 · S/N 15072290 N6790SHildreth Jon R · Spencer, WVBuilt 1967 · S/N 15067590 N67920Thompson William G · Mattawa, WABuilt 1978 · S/N 15282099 N67923Kaluahine Fredstan K · Lihue, HIS/N 15282101 N67924N67924 LLC · Somers, CTBuilt 1978 · S/N 15282102 N6792FPatton Aviation LLC · Billings, MTBuilt 1966 · S/N 15063392 N6792MHouck Mary M · Fish Creek, WIBuilt 1975 · S/N 18263839 N6792RKenley Fredrick C · Palmer, AKBuilt 1980 · S/N 18053156 N6792SJohnston Robert G · Rose Hill, KSBuilt 1967 · S/N 15067592 N67930Colonial Air Inc · New Bedford, MABuilt 1978 · S/N 15282106 N6793AJones Jeffrey D Trustee · Elida, OHBuilt 1956 · S/N 28893 N6793EBig South Fork Aerospace LLC · Pine Knot, KYBuilt 1959 · S/N 56293 N6793FOgden John T · Meridian, IDBuilt 1966 · S/N 15063393 N6793GExecutive Flight Institute LLC · Murrieta, CABuilt 1970 · S/N 15072293 N6793RDelevie Mark Y · Tucson, AZBuilt 1966 · S/N T210-0193 N6794EWalls Jerry L · Hawley, TXS/N 17272067 N6794GLawson Kurt J · Melbourne, FLBuilt 1970 · S/N 15072294 N6794HPs N6794h LLC · Green Bay, WIBuilt 1975 · S/N 17265583 N67958Stone Wall Acres · Antigo, WIBuilt 1978 · S/N 15282115 N6795AKelley Aviation Services Inc · Halifax, PAFirst renewal noticeBuilt 1956 · S/N 28895 N67967Moore Charles E · Gibsonville, NCBuilt 1978 · S/N 15282120 N6796AAjer Richard L · Herriman, UTBuilt 1956 · S/N 28896 N6796EBlain Kyra · Conroe, TXFirst renewal noticeBuilt 1978 · S/N 17272068 N6796GLyon Scott T · Wellsville, KSBuilt 1970 · S/N 15072296

Back to AD 87-20-03 R2