Skip to content

Registered aircraft · 25,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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

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 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 N733SMBoatright Arthur · Live Oak, FLS/N 17268513 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 N733TDFrantzen Elizabeth · Davie, FLBuilt 1976 · S/N 17267136 N733TERedtail Partners LLC · Moab, UTBuilt 1977 · S/N 17268529 N733TJFenton Earl · Puyallup, WABuilt 1977 · S/N 17268533 N733TKCardiff Aviation Inc · Cardiff By The Sea, CABuilt 1977 · S/N 17268534 N733TLRising Wings Aviation Inc · Casper, WYBuilt 1977 · S/N 17268535 N733TPR&R Aero Services LLC · Eden Prairie, MNBuilt 1977 · S/N 17268538 N733TQCarmel Aviation Inc · Boise, IDBuilt 1977 · S/N 17268539 N733TRWenatchee Sport Flyers · Wenatchee, WABuilt 1977 · S/N 17268540 N733TSCox Eileen Xiomara · Davie, FLBuilt 1977 · S/N 17268541 N733TTTeens In Flight Inc · Palm Coast, FLBuilt 1977 · S/N 17268542 N733TVTempleton Bros Construction LLC · Livingston, TXBuilt 1977 · S/N 17268544 N733TXKelley Aircraft LLC · Weyers Cave, VABuilt 1977 · S/N 17268545 N733UAMergen John F · Baltimore, MDBuilt 1977 · S/N 17268548 N733UBKale Larry · Rogers, OHBuilt 1977 · S/N 17268549 N733UCSorbi Aviation Inc · El Cajon, CABuilt 1977 · S/N 17268550 N733UDSpinks Flight Center Inc · Burleson, TXBuilt 1977 · S/N 17268551

Back to AD 80-25-07 R1