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.

N48938International Flying Club Inc · Winfield, ILBuilt 1977 · S/N 15281060 N4893ELjl & D Inc · Wilmington, DEBuilt 1978 · S/N 17271673 N4893GBoldflight LLC · Greenwood, INBuilt 1979 · S/N 17273440 N4893JMartineau Aircraft Inc · Butte, MTBuilt 1979 · S/N 17273692 N48941Somboonsap Patanapong · Fort Lauderdale, FLBuilt 1977 · S/N 15281062 N4894TBar Aviation LLC · Madison, ALBuilt 1981 · S/N R18201782 N4895GWilson Forest B · Hollister, CABuilt 1979 · S/N 17273442 N4895VEbrite Richard P · Long Beach, MSBuilt 1980 · S/N 172RG0410 N4895YKeating George W · Fayetteville, ARBuilt 1980 · S/N 21064033 N48961Sunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 15281074 N48967N48967 LLC · Mount Pleasant, SCBuilt 1977 · S/N 15281079 N4896GGecha Richard Mike · Florence, VTBuilt 1979 · S/N 17273443 N4896KBraxtal LLC · Kingfisher, OKBuilt 1979 · S/N P21000358 N4896MSmtm Holdings Inc · Wilmington, DEBuilt 1981 · S/N 17274294 N4896QBecker Flying Service Inc · Hartington, NEBuilt 1976 · S/N 18802632T N4896RB&R Aerial Crop Care Inc · Connell, WABuilt 1975 · S/N 18802414T N4896VSouth Aero LLC · Albuquerque, NMBuilt 1980 · S/N 172RG0411 N48972Pickett Matthew A DBA · Gig Harbor, WABuilt 1978 · S/N 15281083 N4897ESig Flights LLC · Hickory, NCBuilt 1978 · S/N 17271674 N4897GWings Over Texas Holdings LLC · Denton, TXBuilt 1979 · S/N 17273444 N4898BPrecon Inc · Anaheim, CABuilt 1979 · S/N 15283697 N4898CPalo Aerocraft Inc · Salem, VABuilt 1979 · S/N 21063659 N4898FLima-001 LLC · Muscatine, IABuilt 1979 · S/N 17273097 N4898QTaylor Aviation Inc · Fort Benton, MTBuilt 1976 · S/N 18802634T N48990Hyldburg Aviation · Plymouth, MABuilt 1977 · S/N 15281090 N4899GJf Property Leasing Inc · Port Orchard, WAS/N 17273446 N489ACKuza Flyers LLC · Rock Hill, SCBuilt 1999 · S/N 413-98 N489BCAviation Services Inc · Barre, VTBuilt 1974 · S/N 17264443 N489ERMenefee Scott A · Los Banos, CABuilt 1978 · S/N 17272083 N48BGWhitfill Mark J · Crockett, TXBuilt 1978 · S/N 17271064 N48FHG-Stf LLC · Midland, TXBuilt 1979 · S/N R18201018 N48FMAvworth Aviation Consulting Inc · Florence, KYBuilt 1998 · S/N 24-3428 N48GTBel Air Resources Inc · Bellingham, WABuilt 1994 · S/N 24-3327 N48JAJahawk Leasing LLC · Sugar Grove, ILBuilt 1975 · S/N 17265312 N48JKKeahey Britt · Saint Joseph, LABuilt 1972 · S/N 17260693 N48SUGriffith Aviation Inc · Griffith, INBuilt 1981 · S/N 15285186 N48TDFoster Aviation LLC · Missoula, MTBuilt 1997 · S/N 123297 N49004Oakland Flyers LLC · Oakland, CAS/N 15281094 N49005Sunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 15281095 N4900DCastaneda Jose · Yakima, WAS/N 17272389 N4900HNew Horizon Aviation Inc · Warwick, RIBuilt 1980 · S/N 15284009 N4900LJonghan Park · Stanton, CABuilt 1980 · S/N 15284241 N49024B2fh Ltd · Allentown, NJBuilt 1977 · S/N 15281106 N49025Central Virginia Aviation Inc · North Dinwiddie, VABuilt 1977 · S/N 15281107 N4902FFlying Vikings Inc · Hayward, CABuilt 1979 · S/N 17273099 N4902RBecker Flying Service Inc · Hartington, NEBuilt 1975 · S/N 18802420T N4902SBbsa Flight LLC · Tucson, AZBuilt 1979 · S/N R18201442 N49039Welcome Aviation LLC · Hayward, CABuilt 1977 · S/N 15281115 N49043Edwards Pacific Aviation Corp · Dover, DEBuilt 1977 · S/N 15281117 N4904GC & W Aviation LLC · Trumbull, CTBuilt 1979 · S/N 17273451

Back to AD 80-25-07 R1