Skip to content

Registered aircraft · 54,837

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

N1303UGoodrich Pilot Center LLC · Johnson City, NYBuilt 1976 · S/N 17266995 N1303YDay Patrick J · Bloomer, WIS/N 17249003 N1304FRoach Galen D · Saint John, KSBuilt 1979 · S/N 17272993 N1304MBourg Frederick I · Drummond, WIBuilt 1971 · S/N 15072604 N1304UGiving Wings Aviation LLC · Traverse City, MIBuilt 1976 · S/N 17266996 N1304YLyon Samantha J · Milton, FLS/N 17249004 N13053Skywatch Traffic Inc · Clearwater, FLBuilt 1973 · S/N 17262460 N13056Wings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 17262463 N13058Bouchard Ron R · Lambert, MTBuilt 1973 · S/N 17262465 N13059Zev Aviation LLC · Morristown, NJBuilt 1973 · S/N 17262466 N1305FShlapak Jeffrey M · Peachtree City, GABuilt 1966 · S/N 17254800 N1305QThomas George E · Marietta, OHBuilt 1971 · S/N 15072605 N1305YGraupmann John S · Arlington, WABuilt 1961 · S/N 17249005 N13061Kelly Thomas E · Tequesta, FLFirst renewal noticeBuilt 1975 · S/N 17702396 N13065Pacific Flight Academy LLC · Honolulu, HIBuilt 1973 · S/N 17262471 N13069Tabib Re · Winchester, CABuilt 1973 · S/N 17262472 N1306GCitadel Engineering Inc · Ellendale, DEBuilt 1974 · S/N 310Q1148 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 N1308GRed Over White Aviation · Louisville, KYBuilt 1974 · S/N 310Q1149 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 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 N130HLFair Winds Aviation LLC · Shreveport, LABuilt 1979 · S/N 414A0322 N130RACarter Distribution Lc · Salt Lake City, UTBuilt 1976 · S/N 340A0040 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

Back to AD 97-01-13