Skip to content

Registered aircraft · 40,396

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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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.

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 N733RWalsh John J · Atkinson, NHS/N 733 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 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 N733SBWalker Andrew · Knoxville, TNBuilt 1977 · S/N 17268504 N733SFBurr Ralph C · Smyrna, GABuilt 1977 · S/N 17268507 N733SKRcs Services LLC · California, MDBuilt 1977 · S/N 17268511 N733SLHardin John M · Terrell, TXBuilt 1977 · S/N 17268512 N733SURosas Milton A · Kingsburg, CABuilt 1977 · S/N 17268519 N733SVBeard Mark S · Decker, INBuilt 1977 · S/N 17268520 N733SXTrimble Richard L · Forest City, IABuilt 1977 · S/N 17268522 N733SYDoutt Gerald G · Kalamazoo, MIBuilt 1977 · S/N 17268523 N733TCFlores Omar J · New Braunfels, TXBuilt 1977 · S/N 17268527

Back to AD 79-10-03 R2