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.

N4932SThunder Aviation LLC · Oro Valley, AZBuilt 1980 · S/N R18201471 N4933QDarter Lloyd R · Mountain Grove, MOBuilt 1976 · S/N 18802668T N4933SHedden Larry H · Huntsville, ALBuilt 1980 · S/N R18201334 N49341Dale Michael E · Murrieta, CABuilt 1979 · S/N 15283449 N4934SFerrell Charles A · Stockton, CABuilt 1980 · S/N R18201473 N4935GKip'S Flying Service LLC · Bankston, ALBuilt 1979 · S/N 17273482 N4936TDakma LLC · Parma, OHBuilt 1981 · S/N R18201794 N4937GInternational Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 17273484 N4937PMorcom Aviation Services Inc · Everett, WABuilt 1981 · S/N 15284849 N4937RAllred Bobby A · Centre, ALBuilt 1975 · S/N 18802454T N4937SRauch James A III · Cayce, SCBuilt 1980 · S/N R18201476 N4937TSalsbery Enterprises Inc · Sharpsville, INBuilt 1981 · S/N R18201795 N4938HAir Poueir LLC · Amarillo, TXBuilt 1979 · S/N 15284033 N4938TTilney Five LLC · Belleair, FLBuilt 1981 · S/N R18201796 N4939CBard Ralph M · Tullahoma, TNBuilt 1979 · S/N 21063680 N4939RMiller Farms Jv · Opheim, MTBuilt 1975 · S/N 18802456T N4939SLeriche Daniel R · Wolcott, VTBuilt 1980 · S/N R18201478 N4939VFlorida Keys Flight Academy LLC · Marathon, FLBuilt 1980 · S/N 172RG0420 N4939YDavidson Dan F · Ozona, TXBuilt 1980 · S/N 21064050 N493BTRegistration Pending · Deltona, FLRegistration pendingBuilt 1975 · S/N 17702318 N493SHForsman David G Co-Trustee · South Haven, MNBuilt 1968 · S/N 17256881 N49404Central Virginia Aviation Inc · North Dinwiddie, VABuilt 1977 · S/N 15281240 N4940EFlyright Aviation Inc · North Las Vegas, NVBuilt 1978 · S/N 17271681 N4940GN4940g LLC · Portsmouth, NHS/N 17273487 N4940KGoves Abram M · Parker, COBuilt 1979 · S/N P21000376 N4940SO'Gorman Robert W Jr · Wake Forest, NCBuilt 1980 · S/N R18201479 N49417Rich John E · Dunnellon, FLS/N 15281248 N49419Ds Flight Services LLC · Battle Ground, WAS/N 15281250 N49423Johnson Shem E · Bonners Ferry, IDBuilt 1978 · S/N 15281254 N49424Xin Han Aviation LLC · Atwater, CABuilt 1978 · S/N 15281255 N4942HFlorida Flyers Flight Academy Inc · Saint Augustine, FLBuilt 1979 · S/N 15284036 N49432Northshore Group LLC · Wilmington, DEBuilt 1978 · S/N 15281262 N49434California In Nice Inc · San Jose, CABuilt 1979 · S/N 15283458 N49438Crickmer Charles C · Overton, NVBuilt 1978 · S/N 15281267 N49439Wisconsin Aviation Four Lakes Inc · Madison, WIBuilt 1978 · S/N 15281268 N4943LBonus Kurt · Wind Lake, WIBuilt 1980 · S/N 15284245 N49447Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15281274 N4944RRoma Air Corp · Belle Glade, FLBuilt 1975 · S/N 18802461T N4944SEmbry Riddle Aeronautical University · Prescott, AZBuilt 1980 · S/N R18201483 N49455Above All Aviation Inc · Goleta, CABuilt 1978 · S/N 15281281 N4945TBj Aviation Inc · Littleton, COS/N R18201800 N49461Blue Sky Aviation LLC · Watkins, COBuilt 1978 · S/N 15281287 N4946KOrion Technology Group LLC · San Diego, CABuilt 1979 · S/N P21000378 N49470Stidsen Carlton A · Tolland, CTS/N 15281293 N49471Aeroquest LLC DBA · Olive Branch, MSBuilt 1978 · S/N 15281294 N4947GRiya Aviation LLC · Tracy, CABuilt 1980 · S/N 17273494 N4947QDavison Aviation LLC · Garnett, KSBuilt 1976 · S/N 18802682T N4947SZams Aviation LLC · Raleigh, NCBuilt 1980 · S/N R18201486 N4948GTrece Inc · Adair, OKS/N 17273495 N4948RBlain Monte W · Joliet, MTBuilt 1975 · S/N 18802465

Back to AD 80-25-07 R1