Skip to content

Registered aircraft · 68,369

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-04-06-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-04-06-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-04-06-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-04-06-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-04-06-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-04-06-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.

N12WPSpradlin Flying Service Inc · Petersburg, TXS/N 1013 N12XZ140 LLC · Birmingham, ALS/N 13182 N12YKinslow Eugene C Jr · Prospect, KYBuilt 1965 · S/N 562 N12YCCedarview Airport Investments LLC · Orlando, FLBuilt 2022 · S/N 3395 N12YRHauck Scott · Loveland, OHBuilt 2012 · S/N 5829 N12ZVon Gottsegen Erik · Sweet Home, ORBuilt 1976 · S/N 16 N12ZFJohnson Ross · Anderson, SCBuilt 2000 · S/N 9912CC N12ZX24-3227 Inc Trustee · Wilmington, DEBuilt 1991 · S/N 24-3227 N13004Regnier Ryan A · Lockport, ILBuilt 1973 · S/N 17262439 N13008Midnite Sun Flying Club LLC · Eagle River, AKBuilt 1974 · S/N 17262441 N13009Laffey Joseph C · Saint Louis, MOBuilt 1973 · S/N 17262442 N1300AMann Lee S · Euless, TXBuilt 1966 · S/N 1064 N1300CSelf James M · Fennville, MIBuilt 1953 · S/N 22-1102 N13019Plumer Eric · The Plains, VABuilt 1975 · S/N 17702395 N1301CPiper Aviation Museum Foundation · Lock Haven, PABuilt 1953 · S/N 22-1095 N1301JMoran Francis W Jr · Augusta, GABuilt 1975 · S/N 301 N1301UDonohue Thomas · Carmel, NYBuilt 1964 · S/N 28-20321 N13020Hydeman Aviation Holdings LLC · Sacramento, CABuilt 1973 · S/N 17262449 N1302JAtmos Inc · Kapolei, HIBuilt 1975 · S/N 302 N1302UTraining Planes LLC · Tampa, FLBuilt 1976 · S/N 17266994 N13033Iowa Lakes Community College · Estherville, IABuilt 1973 · S/N 17262453 N13036Hill Shane A · Kalispell, MTS/N 17262455 N13039Cendejas Agustin · Chino, CABuilt 1973 · S/N 17262456 N1303CRodriguez Isaac J · Fort Smith, ARS/N 22-1098 N1303UGoodrich Pilot Center LLC · Johnson City, NYBuilt 1976 · S/N 17266995 N1303WPowell Steven J · Fairview, TXBuilt 1963 · S/N 191 N13048Plane Fun Inc Tr Trustee · Snellville, GABuilt 1995 · S/N 374 N1304ABilben Steve W · Kasilof, AKBuilt 1951 · S/N 18-1108 N1304DGardners Guns & Mfg LLC · Elk City, OKBuilt 1951 · S/N 19880 N1304FRoach Galen D · Saint John, KSBuilt 1979 · S/N 17272993 N1304UGiving Wings Aviation LLC · Traverse City, MIBuilt 1976 · S/N 17266996 N1304WBrihn Rhonda J · Waterford, WIBuilt 1963 · S/N 192 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 N1305AAir Dakota Flite Inc · Hettinger, NDBuilt 1951 · S/N 18-1109 N1305JMans Thomas S · Oakland, TNBuilt 1975 · S/N 305 N1305PParkhill Clifton A Jr Trustee · Oxnard, CABuilt 1955 · S/N 23-345 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 N1306W06 Whiskey Partners · Centennial, COBuilt 1963 · S/N 194 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 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

Back to AD 90-04-06 R1