Skip to content

Registered aircraft · 25,368

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.

N9794VCooke George C IV Trustee · Richland, WABuilt 1974 · S/N 17264505 N9795BSilver Express Co DBA · Miami, FLNon-citizen corporation, flight hours not reportedBuilt 1982 · S/N 172RG1042 N9796VKelley Aircraft LLC · Weyers Cave, VAS/N 17264506 N97983Wintill Gregory S · Roanoke, TXBuilt 1982 · S/N 24-1345 N97984Woody George R · Clinton, ARBuilt 1984 · S/N 17276244 N979LWLapp Daniel · Lincoln, NHBuilt 2002 · S/N 468-2002 N979PTCappe Ivestment Group LLC · Homestead, FLBuilt 1974 · S/N 17264503 N97ACReber Tim · Terrace Park, OHBuilt 1993 · S/N 706-93 N97BCGuy George Hopkins III · Saratoga, CABuilt 2008 · S/N 510-2008 N97BSSidewinder Services LLC · Genoa, NVBuilt 1973 · S/N 17262475 N97CVHigginson Robert W · Minooka, ILBuilt 2022 · S/N 1482-2022 N97DMRegistered aircraftBuilt 1997 · S/N 243409 N97EKern County Sheriffs Department · Bakersfield, CABuilt 1983 · S/N 21064788 N97FRSmith Ralph E · Lyndonville, NYBuilt 1980 · S/N 17274188 N97FZRegistered aircraftBuilt 1997 · S/N 79697 N97GLHarrison Christopher J · Danville, CAS/N 0709 N97JWDorn Albert William II Trustee · Tucson, AZBuilt 1978 · S/N R18200652 N97MWRudderworks Aviation LLC · Fairfax Station, VABuilt 1975 · S/N 17264946 N97PBlack River Construction Services LLC · Black River Falls, WIBuilt 2001 · S/N 881-2001 N9801GTriad Aviation Academy LLC · Greensboro, NCS/N 17259701 N9803CWhite Traci M · Manasquan, NJBuilt 1971 · S/N 17259703 N9805GSell Edwin D · Woodbury, PABuilt 1971 · S/N 17259705 N9806GDonohue Denis J · Montvale, NJBuilt 1971 · S/N 17259706 N9807GPoshak Jay M · Ely, MNS/N 17259707 N9808JPtosis LLC · Fair Oaks, CABuilt 1980 · S/N 17273919 N9809GMcclendon Jon L · Kilgore, TXBuilt 1971 · S/N 17259709 N980HPTopher Enterprises LLC · Bucyrus, KSBuilt 1978 · S/N R18200205 N980JGAir-One Aviation Inc · Searcy, ARFirst renewal noticeBuilt 1978 · S/N 374-79 N980JKKoskan John M · Wood, SDBuilt 1980 · S/N R18201591 N980NOneill Aviation LLC · Lake Wales, FLS/N A1520814 N980SCSky Horse LLC · Santa Cruz, CABuilt 1982 · S/N 21064774 N9810GAir America Flight Center LLC · Daytona Beach, FLBuilt 1971 · S/N 17259710 N9811TAnywhere Atp LLC · Mount Juliet, TNBuilt 1978 · S/N 38-78A0213 N9811VSteffek Mark E · Alturas, CABuilt 1974 · S/N 17264511 N98120Blue River Aviation LLC · Palmer, AKBuilt 1984 · S/N 17276260 N98125Western Reserve Flight Center Inc · Mc Donald, OHBuilt 1984 · S/N 17276261 N9812BPavco Inc · Gig Harbor, WABuilt 1982 · S/N 172RG1046 N9812GWhitfield Robert O Jr · Hurdle Mills, NCBuilt 1974 · S/N 18801607 N9812JMelbourne Flight Training LLC · Melbourne, FLBuilt 1980 · S/N 17273920 N9813BTsiper Evgueni · Eagan, MNBuilt 1982 · S/N 172RG1047 N9813LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276616 N9813VArf Corporation · Brooklyn, NYBuilt 1974 · S/N 17264512 N9815GKenmore Air Harbor LLC · Kenmore, WABuilt 1971 · S/N 17259715 N9815LWestosha Flying Club Inc · Kenosha, WIBuilt 1986 · S/N 17276618 N9816GRicker Harry K · Turner, MEBuilt 1971 · S/N 17259716 N9817GLester Matthew J · Gouldsboro, MEBuilt 1971 · S/N 17259717 N98186Loyer Jeffrey W · Olympia, WAS/N 17276265 N9818GGough Gregory · Emmett, IDBuilt 1971 · S/N 17259718 N981CMClaypool James W · Hunts Point, WABuilt 1998 · S/N 1247-98 N981DCMerten Aviation Services LLC · Holtville, CAS/N 1085-2009

Back to AD 80-25-07 R1