Skip to content

Registered aircraft · 25,370

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.

N4805GTidewater Flying Club Inc · Newport News, VABuilt 1979 · S/N 17273353 N4805KH & M Aviation LLC · Hamilton, OHBuilt 1979 · S/N P21000327 N4805VBudulas Peter Panagiotis · Laurel, MDBuilt 1980 · S/N 172RG0384 N48068Ikarus Aviation LLC · Salt Lake City, UTBuilt 1979 · S/N 15283277 N4806BMckinney Brett A · Hackleburg, ALBuilt 1979 · S/N 15283647 N4806GStone Howard L · Pine Mountain, GABuilt 1979 · S/N 17273354 N4806YCondor Aviation LLC · Hanover, NHBuilt 1980 · S/N 21064012 N4807BSun Aircraft Management LLC · Ormond Beach, FLBuilt 1979 · S/N 15283648 N4807DRussell Matthew D · Chattaroy, WAS/N 17272363 N4807GAdnd LLC · New Ipswich, NHBuilt 1979 · S/N 17273355 N4807JNew England Aviation LLC · Plainville, CTBuilt 1979 · S/N 17273680 N4808DLmnb LLC · Centreville, VABuilt 1979 · S/N 17272364 N4808FYankee Flying Club Inc · Maple Grove, MNBuilt 1979 · S/N 17273084 N4808GClub Aero Inc · Grand Rapids, OHS/N 17273356 N4809RNorthern Air Inc · Bonners Ferry, IDS/N R18200610 N480SCZephyr Services LLC · Long Beach, CABuilt 1978 · S/N R18200455 N480YLauschke Aviation Inc · Rapid City, SDNon-citizen corporation, flight hours not reportedBuilt 1964 · S/N 543 N4810GAndrecheck Cynthia R · Bethel, AKBuilt 1979 · S/N 17273358 N4810YInternational Air Services Inc Trustee · Carson City, NVBuilt 1980 · S/N 21064013 N4811GPoplar Grove Airmotive Inc · Poplar Grove, ILBuilt 1979 · S/N 17273359 N4811JSeals Kenneth P · Munford, ALBuilt 1979 · S/N 17273681 N4813CCivil Air Patrol · Maxwell Afb, ALBuilt 1985 · S/N 17276505 N4813GBasso Michele · Millbrook, ALBuilt 1979 · S/N 17273361 N4813P4813p LLC · Newport, MEBuilt 1978 · S/N P21000115 N4814CKingsky Flight Academy LLC · Lakeland, FLBuilt 1982 · S/N 17275868 N4814DAir Puerto Rico Corp · Aguadilla, PRBuilt 1979 · S/N 17272366 N48156Perdue Ralph R Jr · Blacklick, OHBuilt 1979 · S/N 15283291 N4815CSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1985 · S/N 17276453 N4815HWillis Bobby B · Mckinney, TXBuilt 1979 · S/N 24-0888 N48167American Aviation Inc · Brooksville, FLBuilt 1979 · S/N 15283293 N4816JMorten Derek J · Northwood, NDBuilt 1981 · S/N T18803768T N4816RA&C Ag Aviation Inc · Unadilla, GABuilt 1975 · S/N 18802336T N4816VCollins Lisa A · Lake Dallas, TXBuilt 1980 · S/N 172RG0388 N48176Lucas Bonner · Mckinney, TXBuilt 1965 · S/N 650 N4817BPriority One Insurance & Investments Inc · Hillsboro, NDBuilt 1979 · S/N 15283653 N4818DBald Eagle Flying Club · South Portland, MEBuilt 1979 · S/N 17272367 N4819BSunrise Aviation Inc · Ormond Beach, FLBuilt 1979 · S/N 15283654 N4819GVeer Aviation Tx LLC · Houston, TXBuilt 1979 · S/N 17273367 N4819QPuryear Rodney K · Pampa, TXBuilt 1976 · S/N 18802556T N481ACVogel Lawrence O · Gig Harbor, WAS/N 1289-2000 N481DMEdgewood Capital LLC · Joplin, MOBuilt 2001 · S/N 1307-2001 N481EMClark Jeffrey V · Libertyville, ILBuilt 1996 · S/N 375-96 N481MASlavens Timothy W · Howard City, MIBuilt 2003 · S/N 441-2003 N48204Young Achilles Hsi-Jung · La Habra, CABuilt 1979 · S/N 15283301 N4820DBledsoe Duane C · Glendale, AZBuilt 1979 · S/N 17272369 N4820GAckerman Garry · Plano, TXBuilt 1979 · S/N 17273368 N4820SCalico Construction Inc · Kensington, MDBuilt 1979 · S/N R18201432 N48222N1705r Inc · Cobb, CAS/N 15283303 N48228M & L Utility Contractors Inc · Cottondale, FLBuilt 1979 · S/N 15283304 N4822GHighpoint Strategies LLC · Cypress, TXBuilt 1979 · S/N 17273370

Back to AD 80-25-07 R1