Skip to content

Registered aircraft · 20,683

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.

N733LUTextron Aviation Inc · Wichita, KSS/N 172S13605 N733LYLong Island Aviators LLC · Seaford, NYBuilt 1976 · S/N 17268386 N733MCMann Aviation LLC · Wilmington, DEBuilt 1976 · S/N 17268389 N733MDPaul R Berg Pa · Vero Beach, FLBuilt 1976 · S/N 17268390 N733MGBend Aircraft Mechanics LLC · Bend, ORBuilt 1976 · S/N 17268393 N733MLJennings Jacqueline L · Rome, NYBuilt 1976 · S/N 17268397 N733MPCrawford Alan R · Buchanan Dam, TXBuilt 1976 · S/N 17268399 N733MSNorthgate Aviation Inc · Chico, CABuilt 1976 · S/N 17268402 N733MTWashington Rodney · Mitchellville, MDFirst renewal noticeBuilt 1976 · S/N 17268403 N733MUSanford Aircraft LLC · Winter Springs, FLBuilt 1976 · S/N 17268404 N733MVHarvey Paul E · Richmond, MEBuilt 1976 · S/N 17268405 N733MXWaldron Ronald · Strongsville, OHBuilt 1976 · S/N 17268406 N733MZAnderson Christen M · Tulsa, OKBuilt 1976 · S/N 17268408 N733NBTexins Flying Club · Mckinney, TXBuilt 1976 · S/N 17268410 N733NCRrgsoftware LLC · Alpine, CABuilt 1976 · S/N 17268411 N733NDBas Part Sales LLC · Greeley, COBuilt 1976 · S/N 17268412 N733NEHollenhorst Thomas More · Northfield, MNBuilt 1976 · S/N 17268413 N733NFSchoch George J · Lakewood, WABuilt 1976 · S/N 17268414 N733NKClassic Aviation Inc · Pella, IABuilt 1977 · S/N 17268418 N733NPN733np LLC · Port Orange, FLS/N 17268422 N733NQPerlman Elliot M · Providence, RIBuilt 1976 · S/N 17268423 N733NRGreer Miles · Many, LABuilt 1976 · S/N 17268424 N733NVAero Maintenance Inc · Vancouver, WAS/N 17268428 N733NWLeatherwood John W · Corinth, MSBuilt 1976 · S/N 17268429 N733PDThree Tree Aviation LLC · Natchez, MSBuilt 1976 · S/N 17268435 N733PGPn Aero LLC · Caldwell, NJBuilt 1976 · S/N 17268438 N733PNAerospring Leasing LLC DBA · Wasilla, AKBuilt 1976 · S/N 17268444 N733PQSeppmann Benlyn · Lake Crystal, MNBuilt 1976 · S/N 17268446 N733PVCalifornia Airways LLC · Hayward, CABuilt 1976 · S/N 17268451 N733PXWest Bend Air Inc · West Bend, WIBuilt 1976 · S/N 17268453 N733PYRsa Flight Training LLC · Morgantown, WVBuilt 1977 · S/N 17268454 N733QAParrillo Development And Real Estate LLC · Sarasota, FLBuilt 1976 · S/N 17268456 N733QGCarter Flygare Inc · Sacramento, CABuilt 1976 · S/N 17268461 N733QHSt Charles Flying Service Inc · Portage Des Sioux, MOBuilt 1976 · S/N 17268462 N733QJRick Aviation Inc · Newport News, VABuilt 1976 · S/N 17268463 N733QQHenley Johnny J · Trenton, NCBuilt 1976 · S/N 17268469 N733QXVaughan Stephen D · Finchville, KYBuilt 1976 · S/N 17268476 N733QYKlassen Harvey L · Springport, MIBuilt 1976 · S/N 17268477 N733QZHogan Robert P · North Pole, AKBuilt 1976 · S/N 17268478 N733RALilly Daryl A · Winterset, IABuilt 1976 · S/N 17268479 N733RDSzoke Thomas L · Walnutport, PABuilt 1976 · S/N 17268482 N733RFBaymax Aviation LLC · Ronkonkoma, NYBuilt 1976 · S/N 17268484 N733RGPalo Alto Flyers · West Bend, IAFirst renewal noticeS/N 17268485 N733RJMarti Jed B · Salt Lake City, UTBuilt 1976 · S/N 17268179 N733RNLugert David C · Placerville, CABuilt 1976 · S/N 17268491 N733RT661pc LLC · New Rockford, NDBuilt 1977 · S/N 17268496 N733RUShogbonyo Michael A · Arlington, TXBuilt 1977 · S/N 17268497 N733RVHanley Thomas W · Kissimmee, FLBuilt 1977 · S/N 17268498 N733RWGeterdun LLC · Stowe, VTBuilt 1977 · S/N 17268499 N733RYGeaux Giddum 1 LLC · Brandon, MSBuilt 1977 · S/N 17268501

Back to AD 90-06-03 R1