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.

N9888CLoehde Thomas · Lolo, MTBuilt 1978 · S/N R18200485 N9888GRegistration Pending · Atlanta, TXRegistration pending, pending cancellationBuilt 1971 · S/N 17259788 N9888JHoran Lawrence J · Terrell, TXS/N 17273951 N98893Pape Jason C · Sykesville, MDBuilt 1985 · S/N 17276374 N9889GWright Flight Inc · Tucson, AZBuilt 1971 · S/N 17259789 N9889QTack-Morse Patricia M · Sweet Home, ORBuilt 1975 · S/N 17265833 N9889YTharp Rodney W · Thomasville, NCBuilt 1981 · S/N 21064629 N988BGMojo Flight Group LLC · Gainesville, GABuilt 1975 · S/N 17265795 N988MTurecek Peter J · Fairfield, CTS/N R18201357 N9890YValiair Lc Trustee · Casper, WYS/N 21064630 N98913Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276378 N9891GOuellette Kevin E · Frederick, OKBuilt 1971 · S/N 17259791 N98923Costa Flying Service Inc · Painted Post, NYBuilt 1985 · S/N 17276381 N9892GFritz John P · Belvidere, NJBuilt 1971 · S/N 17259792 N9892QLytle Jack J · Omaha, NEBuilt 1975 · S/N 17265836 N9893QDougherty Casey · Rock Island, WABuilt 1975 · S/N 17265837 N9894G1s6 Flying Club Inc · Sandpoint, IDS/N 17259794 N9894QKarpov Konstantin A Trustee · Fort Bragg, CABuilt 1975 · S/N 17265838 N9894YRaymond Andy · Council Bluffs, IABuilt 1981 · S/N 21064632 N98954Emerson Solutions LLC · Bellingham, WABuilt 1985 · S/N 17276384 N9895GKellerman Roger B · Rockford, ILBuilt 1971 · S/N 17259795 N9895QCk Leasing Services LLC · Wilmington, DEBuilt 1975 · S/N 17265839 N9895VTogo Aviation Services LLC · Palmer, AKBuilt 1974 · S/N 17264550 N98960Buiqui Aerospace Corp · Kissimmee, FLBuilt 1985 · S/N 17276387 N9897QAbove All Aviation Inc · Santa Barbara, CABuilt 1975 · S/N 17265841 N98981Airplane And Drone Flight Instruction LLC · Orlando, FLBuilt 1985 · S/N 17276390 N98987Civil Air Patrol Inc · Maxwell Afb, ALS/N 17276391 N98989Aurellium Corp · Bettendorf, IAS/N 24-1088 N9898QSecond Wind Aviation Corp · Friday Harbor, WABuilt 1975 · S/N 17265842 N9899ARhodes William D Jr · New Tazewell, TNBuilt 1981 · S/N 24-1089 N9899GWings Over Texas LLC · Denton, TXBuilt 1971 · S/N 17259799 N9899QBrown Richard K · East Falmouth, MABuilt 1975 · S/N 17265843 N989CDDoyle Charles P · Webster, MNBuilt 2008 · S/N 1075-2008 N989CWCardinal Wings Aviation LLC · Buckner, KYBuilt 1976 · S/N 17266884 N989PMGasper Michael J · Malvern, OHBuilt 1989 · S/N 24-3113 N989TGSouthern Airmotive Inc · Texic, NMBuilt 1980 · S/N 24-1054 N989WBCp Aviation Inc · Santa Paula, CABuilt 2012 · S/N 1120-2012 N98ABooe Kent W · Clay City, INBuilt 1973 · S/N 64-73 N98BRGrant Brian · Durham, NCBuilt 1995 · S/N 24-3356 N98DXInternational Air Services Inc Trustee · Carson City, NVS/N 17272526 N98EMGreen Tool & Die Co LLC · Honesdale, PABuilt 1968 · S/N 17256804 N98GCGarcia Alexandra · Pompano Beach, FLBuilt 1968 · S/N 17257750 N98GPHammack Philip Scott · Canton, MSS/N R18201593 N98JSErstad Eldon D · Maple Lake, MNBuilt 1968 · S/N 680122 N98SWGankas Christopher · Ventura, CABuilt 1976 · S/N 177RG1090 N98ZTSharp Paul A II · Apollo Beach, FLBuilt 1971 · S/N 17259956 N9900QBedsole Clinton Allen · Frisco, TXBuilt 1975 · S/N 17265844 N9902QBowers John E · Owasso, OKBuilt 1975 · S/N 17265846 N9903VDwh Flight LLC · Spring, TXBuilt 1974 · S/N 17264552 N99040Bradley Aircraft Company LLC · Columbus, INBuilt 1985 · S/N 17276395

Back to AD 80-25-07 R1