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.

N737BDMusic City Air LLC · Rogersville, ALBuilt 1977 · S/N 17269284 N737BEAdventure Flying LLC · Carrollton, GAS/N 17269285 N737BKDesert Sand Aircraft Leasing Co Inc · Rosharon, TXBuilt 1977 · S/N 17269289 N737BMEnnis James D · Eminence, MOS/N 17269291 N737BQReynolds Darryl G · Wills Point, TXS/N 17269294 N737BTCharlie Lima 1 LLC · Jacksonville, FLBuilt 1977 · S/N 17269297 N737BUAero Equities LLC · Ventura, CABuilt 1977 · S/N 17269298 N737BWPietsch Aircraft Restoration & Repair Inc · Minot, NDS/N 17269300 N737CAKestrel Enterprises LLC · Santa Fe, NMS/N 17269304 N737CBR&R Aero Services LLC · Eden Prairie, MNBuilt 1977 · S/N 17269305 N737CEScanlan Michael · Carmel Valley, CAS/N R18200818 N737CHCharlie Lima 1 LLC · Jacksonville, FLS/N 17269310 N737CKFreiberg Alan E · Mobile, ALBuilt 1977 · S/N 17269312 N737CNSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 17269315 N737CPFlight Exams Inc · Deland, FLBuilt 1977 · S/N 17269316 N737CQDo Aviation LLC · Elgin, SCBuilt 1977 · S/N 17269317 N737CVDeland Aviation LLC · Deland, FLBuilt 1978 · S/N 17269322 N737CWWakefield Aviation LLC · Riverton, UTBuilt 1977 · S/N 17269323 N737CXEb Flight Training LLC · Daytona Beach, FLS/N 17269324 N737CZMt Vernon Airport Authority · Mount Vernon, ILBuilt 1977 · S/N 17269326 N737DASky II LLC · Lees Summit, MOBuilt 1977 · S/N 17269327 N737DCBirkenhead Judy · College Park, MDBuilt 1977 · S/N 17269329 N737DDSorbi Aviation Inc · El Cajon, CABuilt 1977 · S/N 17269330 N737DESky Creation Inc · Torrance, CABuilt 1977 · S/N 17269331 N737DGEagle Aviation LLC · Spearfish, SDS/N 17269333 N737DJYoungs Farm Blue Mountain Ranch LLC · Paulina, ORBuilt 1977 · S/N 17269335 N737DLRobertson Steven J Trustee · Escondido, CABuilt 1977 · S/N 17269337 N737DMAbove & Beyond Aviation Inc · Anchorage, AKBuilt 1977 · S/N 18503307 N737DPAero Photo · Spicewood, TXBuilt 1977 · S/N 17269340 N737DRVannote Eugene L · Belews Creek, NCBuilt 1977 · S/N 17269342 N737DSEmpty Nest LLC · Glen Ellen, CABuilt 1977 · S/N 17269343 N737DTAdvance Aviation LLC · Mount Vernon, IABuilt 1977 · S/N 17269344 N737DVSuperior Flying Services LLC · Superior, WIBuilt 1977 · S/N 17269346 N737DWMh Aviation Inc · Lancaster, CABuilt 1977 · S/N 17269347 N737DYAsset Flight LLC · Beaumont, TXS/N 17269349 N737ECBlock Craig L · Murrieta, CABuilt 1977 · S/N 17269353 N737EERising Wings Aviation Inc · Casper, WYBuilt 1977 · S/N 17269355 N737EGWilson Scott A · Livingston, LABuilt 1977 · S/N 17269356 N737EHGiese Douglas S · San Angelo, TXS/N 17269357 N737EMPreston Richard R Trustee · Albuquerque, NMBuilt 1977 · S/N 17269361 N737EPN737ep Partners LLC · Blue Jay, CABuilt 1977 · S/N 17269363 N737ESNovember Seven Echo Sierra LLC · Pineville, LABuilt 1977 · S/N 17269366 N737ETOptima Aviation LLC DBA · Lewisville, TXBuilt 1977 · S/N 17269367 N737EWOklahoma Airmen Flying Club Inc · Jenks, OKBuilt 1977 · S/N 17269370 N737FDMeadows Stone & Paving Inc · Gassaway, WVBuilt 1977 · S/N 17269377 N737FFWorley Donald E Jr · Rocky Mount, VAS/N R18200819 N737FHEagle Simulator LLC · Lake Oswego, ORS/N 17269381 N737FJVero Technical Support Inc · Pensacola, FLBuilt 1977 · S/N 17269382 N737FRShepard Christopher N · Westerville, OHBuilt 1978 · S/N R18200820 N737FUWarren Darryl · Clinton, ARBuilt 1978 · S/N R18200823

Back to AD 87-20-03 R2