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.

N88DRAkerson Charles J · Clarksville, TNBuilt 1965 · S/N 3170 N88EStarlite Aviation Technologies LLC · Las Vegas, NVBuilt 1973 · S/N 17261476 N88EFPeyton Craig L · Rhinebeck, NYBuilt 1979 · S/N 24-0815 N88EYMazur Paul · Cottage Grove, MNFirst renewal noticeBuilt 1989 · S/N 24-3128 N88KMTsukii Toshikazu · Tucson, AZBuilt 1977 · S/N 177RG1181 N88LLLarrabee Consulting Group LLC · West Carrollton, OHBuilt 1977 · S/N 973-77 N88NGBakke Dale W · Yankton, SDBuilt 1977 · S/N 177RG1223 N88NVPhillips Mark L F · Albuquerque, NMFirst renewal noticeS/N 1287-79 N88SSWasson Trevor J · Whitewater, MTBuilt 1976 · S/N 205-76 N88SYYamashita Bruce · Honolulu, HIBuilt 1969 · S/N 17258613 N88YWCharlston Michael M · Haleiwa, HIS/N 15283335 N89021Tevik Michael A · Provo, UTBuilt 1978 · S/N 15282598 N8902VFlycarolina LLC · Concord, NCS/N 17264259 N89038Gross Matthew D · Saint Paul, MNFirst renewal noticeBuilt 1978 · S/N 15282606 N8904VWaymaker Aviation LLC · Yukon, OKBuilt 1974 · S/N 17264261 N89054Stcup 152 LLC · Chicago, ILBuilt 1978 · S/N 15282611 N89055Hageman George · Pebble Beach, CABuilt 1978 · S/N 15282612 N8906VLewis David A · Broadalbin, NYBuilt 1974 · S/N 17264263 N89071Pavco Inc · Gig Harbor, WABuilt 1978 · S/N 15282617 N89073O Reilly Thomas P · Oscoda, MIBuilt 1978 · S/N 15282618 N89090Huggins Elissa D · El Paso, TXBuilt 1978 · S/N 15282626 N89098Dobbelaere Craig · Oakwood, OHBuilt 1978 · S/N 15282630 N89114Drop Table Airplanes LLC · San Anselmo, CABuilt 1978 · S/N 15282638 N8911VHorizon Dreams LLC · Homer, GABuilt 1974 · S/N 17264268 N8912VRoper Jeff A · Corralitos, CABuilt 1974 · S/N 17264269 N89132Affiliated Air Services Inc · Southampton, NJBuilt 1978 · S/N 15282642 N8913VI'Ll Fly Away LLC · Florence, SCBuilt 1974 · S/N 17264270 N89159Napiecek Sarah · Kyle, TXBuilt 1978 · S/N 15282654 N8916VTaylor William W Jr · Hudson Oaks, TXBuilt 1974 · S/N 17264273 N89186Hangar 47 Aviation LLC · Midvale, UTBuilt 1978 · S/N 15282665 N89192Stone Christopher B · High Point, NCBuilt 1978 · S/N 15282668 N89197Campbell Michael R · Aurora, NES/N 15282670 N8919VChristiansen John · Vicksburg, MIBuilt 1974 · S/N 17264276 N891DBSpivak Maxim · San Jose, CABuilt 2001 · S/N 891-2001 N891JTTrowbridge Jason Wesley · Arlington, TNBuilt 1973 · S/N 584-80 N89215Delgado Ruben E · San Antonio, TXBuilt 1978 · S/N 15282676 N8921VN2827n LLC · Pembroke Pines, FLS/N 17264278 N8922Culver Marc D · Anchorage, AKBuilt 1973 · S/N 493-73 N89226Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 15282682 N8922VTampa Bay Aviation Inc · Clearwater, FLBuilt 1974 · S/N 17264279 N8923Brockway Troy D · Salina, KSBuilt 1973 · S/N 481-73 N8924VDupree Johnny · Crossett, ARBuilt 1974 · S/N 17264281 N8926Johnson David H · Jasper, GABuilt 1973 · S/N 367-73 N8926VCareer Flight Training And Aircraft Rental LLC · Naples, FLBuilt 1974 · S/N 17264283 N8927Bevis Kenneth D · Richwood, OHS/N 48273 N89273Anderson Ben H · Fort Smith, ARBuilt 1978 · S/N 15282697 N8927VTropical Aviation LLC · Gulf Shores, ALBuilt 1974 · S/N 17264284 N8928Anding Jay B · Bryan, TXBuilt 1973 · S/N 483-73 N8929Cavanagh James B · Litchfield Park, AZBuilt 1973 · S/N 255-73 N892SGCraik Evelyn June · Las Vegas, NVBuilt 1966 · S/N 1114

Back to AD 80-25-07 R1