Skip to content

Registered aircraft · 20,687

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:90-06-03-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-03-R1') 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:90-06-03-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-03-R1')
  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:90-06-03-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-03-R1')
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.

N99338Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276433 N99341Jlinn Aviation Inc · Quinlan, TXBuilt 1985 · S/N 17276434 N99344Global Tours & Travel Services LLC · Davie, FLS/N 17276435 N99347Skywarrior Flight Training Inc · Pensacola, FLBuilt 1985 · S/N 17276436 N9934QDoupe Services LLC · Fort Myers, FLBuilt 1975 · S/N 17265878 N9935FKrahe Richard P · Willoughby, OHBuilt 1999 · S/N 17280645 N9935VD & S Aviation LLC · Wilmington, DEBuilt 1974 · S/N 17264562 N9936QHunt Richard M · Columbus, OHBuilt 1975 · S/N 17265880 N9936VLeading Edge Flight Academy LLC · Bend, ORBuilt 1974 · S/N 17264563 N99377Barta Terry · Faribault, MNBuilt 1985 · S/N 17276439 N9937E7 And 7 LLC · Leon, IABuilt 1979 · S/N 17272293 N9937QFosmo Richard E · Eatonville, WABuilt 1975 · S/N 17265881 N99396Flightline Air Service LLC · Pineville, LABuilt 1985 · S/N 17276441 N993CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1998 · S/N 17280317 N993PDCertified Aviation LLC · Morristown, NJBuilt 1999 · S/N 172S8306 N9940VSoco Aero Leasing LLC · Santa Rosa, CABuilt 1974 · S/N 17264566 N9942QWarren John Russell · Los Alamos, NMBuilt 1975 · S/N 17265886 N9943ELerud Peder E · Stockton, CABuilt 1979 · S/N 17272294 N9943QGrove Todd M · Lake Stevens, WABuilt 1976 · S/N 17265887 N99442Sale Reported · Kissimmee, FLSale reported, pending cancellationS/N 17276447 N9944QSkywarrior Flight Training Inc · Pensacola, FLBuilt 1975 · S/N 17265888 N9945EWilcox John C · Aurora, NEBuilt 1979 · S/N 17272295 N9945QClassic Air Aviation LLC · Mesa, AZBuilt 1975 · S/N 17265889 N99465Farzam Hamid · Newington, CTBuilt 1985 · S/N 17276450 N99467Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276451 N9946QHorizon Aviation LLC · Sinclair, MEBuilt 1975 · S/N 17265890 N994LAJaguar Aviation LLC · Hillsboro, ORBuilt 2024 · S/N 172S13120 N994NACurry Lloyd F · Karnack, TXBuilt 1966 · S/N 17254820 N994WWMabry Properties And Holdings LLC · Jonesboro, ARBuilt 1999 · S/N 17280719 N99508Lee Randall Ross · Houston, TXBuilt 1985 · S/N 17276456 N99517Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276459 N9951V9951v Aircraft Leasing LLC · Spanish Fork, UTS/N 17264569 N99527Delta State University · Cleveland, MSBuilt 1985 · S/N 17276460 N99532Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276462 N99553Jka LLC · Notasulga, ALBuilt 1985 · S/N 17276465 N9957EReisman Richard H · Montrose, COBuilt 1979 · S/N 17272298 N99583Motz Gary A · Bemidji, MNBuilt 1985 · S/N 17276471 N99589Kingsky Flight Academy LLC · Lakeland, FLBuilt 1985 · S/N 17276472 N99598Registration Pending · Argyle, TXRegistration pendingBuilt 1985 · S/N 17276474 N995CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1997 · S/N 17280319 N995JAN995ja LLC · Ft Lauderdale, FLBuilt 1974 · S/N 17263989 N995NABucher Devin V · Kalispell, MTBuilt 1966 · S/N 17255575 N995WWMoore Aviation Inc · Beaver Falls, PABuilt 1999 · S/N 17280720 N99606Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276478 N9960EArklamiss Aviation LLC · Ruston, LAS/N 17272299 N9961ERuryk Jonathan D · Pineville, LABuilt 1979 · S/N 17272300 N9961VCk Leasing Services LLC · Wilmington, DEBuilt 1974 · S/N 17264579 N9963EDenski David T · Plymouth, MIBuilt 1979 · S/N 17272301 N9964LHess Garrett J · Fullerton, CABuilt 1986 · S/N 17276652 N9965PAmeriflyers Of Texas Inc · Addison, TXBuilt 2008 · S/N 172S10822

Back to AD 90-06-03 R1