Skip to content

Registered aircraft · 17,027

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

N2873QCloud Dancer Aviation Inc · Deland, FLBuilt 1971 · S/N 17259873 N2873YMorris Ben M · Albany, GABuilt 1962 · S/N 18253873 N2874LSchirack John · Decatur, INBuilt 1967 · S/N 17256074 N2875LDavenport Ross K · Raleigh, NCBuilt 1967 · S/N 17256075 N2875QLani Lea Sky Tours LLC · Honolulu, HIBuilt 1971 · S/N 17259875 N2875SHolland Van D · Sandy Valley, NVBuilt 1967 · S/N 15066775 N2876FJohnston Natalie R · Edgewood, TXBuilt 1966 · S/N 18256976 N2876SRay Charlie B · Prosser, WAS/N 15066776 N2876YForbes Richard L · Plano, TXBuilt 1962 · S/N 18253876 N2877SWarner David F · Altoona, IABuilt 1967 · S/N 15066777 N2877XJim Doherty Trucking Inc · Sacramento, CABuilt 1967 · S/N 17700277 N2877YBrumback Recreation LLC · Bluffdale, UTBuilt 1962 · S/N 18253877 N2878LHolbrook David A · Toccoa, GABuilt 1967 · S/N 17256078 N2878QFields Williams H · Greensboro, NCBuilt 1971 · S/N 17259878 N2879FMinich Sophie R · Anchorage, AKS/N 18256979 N2879QBlue Side Aviation LLC · Tampa, FLBuilt 1971 · S/N 17259879 N2879XGregoire Louis Bernard III · Blairsville, GABuilt 1967 · S/N 17700279 N287TCAiv Con Inc · Charlevoix, MIBuilt 1969 · S/N 18260183 N2880RPhelps Thomas J · Orem, UTBuilt 1967 · S/N 18258480 N2880SHigh Exposure Inc · Wilmington, DEBuilt 1967 · S/N 15066780 N2880XGerstung Dennis R · Anchorage, AKBuilt 1967 · S/N 17700280 N2880YRegistered aircraftBuilt 1962 · S/N 18253880 N2881LCore Alan L · Indianola, IABuilt 1967 · S/N 17256081 N2881QNeenah Aircraft Leasing LLC · Neenah, WIBuilt 1971 · S/N 17259881 N2881SSerbus Gary E · Olivia, MNBuilt 1967 · S/N 15066781 N28822Edwards Gordon O · Casper, WYBuilt 1966 · S/N 15063015 N2882YVx Aviation LLC · Palisade, COBuilt 1962 · S/N 18253882 N2883RCallegari Sergio P · Reno, NVBuilt 1967 · S/N 18258483 N2883XRamano Raymond C · Napa, CABuilt 1967 · S/N 17700283 N2884FTurner Michael B · Covington, TNBuilt 1966 · S/N 18256984 N2884RSalem Coastal Enterprises LLC · Elizabeth City, NCFirst renewal noticeBuilt 1967 · S/N 18258484 N2884YTri-Aviation Inc · Amarillo, TXBuilt 1962 · S/N 18253884 N2885LBlevens George A Jr · Franklin, KYS/N 17256085 N2885QFisher Global LLC · Conway, ARBuilt 1971 · S/N 17259885 N2885SWinter Thomas N · Lincoln, NEBuilt 1967 · S/N 15066785 N2885YMiner Bradford Aviation LLC · Spanish Fork, UTS/N 18253885 N2886FWeldon Larry W · Titusville, PABuilt 1966 · S/N 18256986 N2886QWright Flyers Club Inc · Huber Heights, OHBuilt 1971 · S/N 17259886 N2887LMello Stephen F · Ludlow, MABuilt 1967 · S/N 17256087 N2887RNaylor Michael Scott · Modesto, CABuilt 1967 · S/N 18258487 N2887SRobinson Andrew K · Pahrump, NVBuilt 1967 · S/N 15066787 N2887XTolmachev Nikolay A · Anchorage, AKS/N 17700287 N2888FLynch Neil E · Ceresco, MIBuilt 1966 · S/N 18256988 N2888QChilds William C · Bridgeport, ALS/N 17259888 N2889FLander Kirt E · Kingman, AZBuilt 1966 · S/N 18256989 N2889LSouthern Star Aviation LLC · Missoula, MTBuilt 1967 · S/N 17256089 N2889RAircraft Structural Repair Inc · Hamilton, MTBuilt 1967 · S/N 18258489 N2889SKinter Christopher A · Kodiak, AKS/N 15066789 N2889XKogele Donald J · Broadus, MTBuilt 1967 · S/N 17700289 N2889YJust Jump Skydiving LLC · Laurens, NYBuilt 1962 · S/N 18253889

Back to AD 72-03-03 R3