Skip to content

Registered aircraft · 54,020

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.

N13065Pacific Flight Academy LLC · Honolulu, HIBuilt 1973 · S/N 17262471 N13069Tabib Re · Winchester, CABuilt 1973 · S/N 17262472 N1306QCompton Kenneth Dale · Mebane, NCS/N 15072606 N1306YOklahoma Flight Academy LLC · Owasso, OKBuilt 1961 · S/N 17249006 N13076Smith Jimmy R · Bowling Green, KYBuilt 1973 · S/N 17262477 N13077Raborn Albert F · Collinsville, VABuilt 1973 · S/N 17262478 N13078Nichols Patrick C · Fairview, NCBuilt 1973 · S/N 17262479 N13079Great Lakes Air Inc · Alpena, MIBuilt 1973 · S/N 17262480 N1307GPray Aviation Inc · Augusta, KSBuilt 1966 · S/N 17254120 N1307YOrange County Flight Center Inc · Santa Ana, CABuilt 1961 · S/N 17249007 N13081Eagle East Aviation Inc · North Andover, MABuilt 1973 · S/N 17262481 N13083Cloud Surfer N13083 LLC · Helena, MTBuilt 1973 · S/N 17262483 N13084Lutz Kelly L · Auburndale, FLBuilt 1976 · S/N 17702397 N1308SCecil Donald C · Willows, CABuilt 1976 · S/N 18264873 N1308UCarson Danny L · Oneida, TNBuilt 1966 · S/N 15065444 N1308YBrewer Lester A · Magna, UTFirst renewal noticeS/N 17249008 N13093Multiflight II Inc · Lakeville, MNBuilt 1973 · S/N 17262488 N13095Air Ally Asset Management LLC · Chisago City, MNBuilt 1973 · S/N 17262489 N13096Flights Cool LLC · La Conner, WABuilt 1973 · S/N 17262490 N13099Steeber Pauline M · Mcmurray, PABuilt 1973 · S/N 17262493 N1309DOld Buzzard Aviation Inc · Middleburg, FLBuilt 1951 · S/N 19885 N1309QSteenbarger Summer D · Woodland, WAS/N 15072609 N1309SBlackburn Mark R · Saint Paul, KSBuilt 1976 · S/N 18264874 N1309U129w Holdings LLC · Terlingua, TXBuilt 1976 · S/N 17266999 N1309YC747 LLC · Wilmington, DEBuilt 1961 · S/N 17249009 N130CFFlying C Leasing Ltd · Wilmington, DEBuilt 1977 · S/N 15279509 N130DABornheber Ralf · DraskovicS/N 17265713 N130HJJaynes Grayson V · Burnet, TXS/N 15068617 N130RCWilliams Brian G · Las Cruces, NMBuilt 1983 · S/N P21000822 N130RVUddin Nazim · Buffalo, NYS/N 15072090 N130TCVogt Richard L · Panama City Beach, FLBuilt 1976 · S/N 18264999 N13100Ruttenberg Barbara A · Lexington, KYBuilt 1973 · S/N 17262494 N13101North Hollywood Optimist Club Youth · Van Nuys, CABuilt 1973 · S/N 17262495 N13104Erley Robert B · Kirkland, WABuilt 1973 · S/N 17262498 N13108Registered aircraftBuilt 1976 · S/N 17702398 N13109Illinois Valley Flying Club · Peru, ILBuilt 1973 · S/N 17262503 N1310FHumphries Aviation LLC · Maysville, KYBuilt 1966 · S/N 17254805 N1310VMilton N1320v LLC · Helena, MTBuilt 1976 · S/N R1722160 N13115Kkmjj LLC · South Lyon, MIBuilt 1973 · S/N 17262507 N13117Mccullough James R · Newville, PABuilt 1973 · S/N 17262509 N13119Boomer Aviation LLC · Catoosa, OKBuilt 1973 · S/N 17262511 N1311DAntkowiak Colton C · Chugiak, AKBuilt 1951 · S/N 19887 N1311LCarpe Diem Atb LLC · Northfield, MNS/N 33701804 N1311SCutlass 661 LLC · Orange Park, FLBuilt 1976 · S/N 18264876 N13127Fisher Global LLC · Conway, ARBuilt 1973 · S/N 17262517 N13128Huffman David L · Corsicana, TXBuilt 1976 · S/N 17702400 N13129Giartlau Aviation Corp · Minneola, FLBuilt 1973 · S/N 17262519 N1312EBuswell Aviation Inc · Salem, ORBuilt 1978 · S/N 17270950 N1312FBill Stephan · Ellenville, NYBuilt 1966 · S/N 17254807 N1312LMccole Kevin · Brookline, NHBuilt 1977 · S/N 33701805

Back to AD 87-20-03 R2