Skip to content

Registered aircraft · 40,473

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-04-03-R2') 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-04-03-R2') 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-04-03-R2')
    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-04-03-R2')
  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-04-03-R2')
  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-04-03-R2')
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.

N4882AWilliams Donald B · Wingate, NCS/N 18-4982 N4882LArapahoe Flight Club LLC · Colorado Springs, COBuilt 1967 · S/N 28-4248 N4883GPlane Nuts Aviation LLC · Livingston, LABuilt 1979 · S/N 17273430 N4883LMeixel Aviation LLC · Starbuck, MNBuilt 1967 · S/N 28-4249 N4884AGarfield Joe T · Morgan, UTBuilt 1956 · S/N 18-4985 N4885DSpartan National Holdings LLC · Missoula, MTBuilt 1979 · S/N 17272386 N4885GS&P Aviation LLC · Albuquerque, NMS/N 17273432 N4885LMaximize Solutions Inc · Swan Lake, NYBuilt 1967 · S/N 28-4251 N4886ACook Timothy D · Ashville, NYBuilt 1956 · S/N 18-4987 N4886GSkycrafters Inc · Johnson City, TNFirst renewal noticeBuilt 1979 · S/N 17273433 N4886LNortheast Florida Aero Club Inc · Fleming Island, FLBuilt 1967 · S/N 28-4252 N4887GSouthern Aero LLC · Homestead, FLBuilt 1979 · S/N 17273434 N4887TRoe John C · Bonners Ferry, IDS/N 28-7225230 N4888G578 Airplane Leasing Inc · Kissimmee, FLS/N 17273435 N4888TTevik Michael A · Provo, UTBuilt 1972 · S/N 28-7225231 N4888ZFrancom Jeffery S · Malad City, IDS/N 22-8470 N4889DPink Skies Inc · Willoughby, OHBuilt 1979 · S/N 17272387 N4889GKittitas Aero Inc · Kittitas, WABuilt 1979 · S/N 17273436 N4889LWerner Joseph H · Wauconda, ILBuilt 1967 · S/N 28-4255 N4889TS&P Aviation LLC · Albuquerque, NMS/N 28-7205217 N488CMEmery Kenneth Russell Jr · Odessa, FLBuilt 2011 · S/N 73322 N488JWKagey David M · Seabrook, TXBuilt 1972 · S/N 17261113 N488LGErnst Donald E · North Pole, AKBuilt 1975 · S/N 14175 N488RRMenke Rex A · Medical Lake, WABuilt 1972 · S/N 93 N488XHahn Jesse J · Cedar Rapids, IAS/N 5111 N489Snyder Ralph J · Colorado Springs, COBuilt 1993 · S/N 20003 N4890PSale Reported · Willow, AKSale reportedBuilt 1961 · S/N 18-7762 N4890UUniversity Of Oklahoma · Norman, OKBuilt 2005 · S/N 2842235 N4891JHarris Aircraft Leasing Co · Oklahoma City, OKBuilt 1979 · S/N 17273691 N4891LToga LLC · Dayton, VABuilt 1967 · S/N 28-4258 N4891TRoss Stephen C · Santa Fe, NMBuilt 1972 · S/N 28-7205219 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 N4894LPeairs Gregory Ross · Sacramento, CABuilt 1967 · S/N 28-4261 N4895GWilson Forest B · Hollister, CABuilt 1979 · S/N 17273442 N4895VEbrite Richard P · Long Beach, MSBuilt 1980 · S/N 172RG0410 N48966Kapellair LLC · Wickenburg, AZBuilt 1943 · S/N 230 N4896GGecha Richard Mike · Florence, VTBuilt 1979 · S/N 17273443 N4896LMike Delta Kilo LLC · Bentonville, ARBuilt 1967 · S/N 28-4263 N4896MSmtm Holdings Inc · Wilmington, DEBuilt 1981 · S/N 17274294 N4896TVosler Dean S · Bay City, MIBuilt 1972 · S/N 28-7225233 N4896VSouth Aero LLC · Albuquerque, NMBuilt 1980 · S/N 172RG0411 N4897ESig Flights LLC · Hickory, NCBuilt 1978 · S/N 17271674 N4897FGnl Aviation LLC · Weatherford, OKFirst renewal noticeBuilt 1976 · S/N 28-7790071 N4897GWings Over Texas Holdings LLC · Denton, TXBuilt 1979 · S/N 17273444 N4898FLima-001 LLC · Muscatine, IABuilt 1979 · S/N 17273097 N4899GJf Property Leasing Inc · Port Orchard, WAS/N 17273446 N4899LSweat Larry D · Meridian, IDBuilt 1967 · S/N 28-4266 N489ACKuza Flyers LLC · Rock Hill, SCBuilt 1999 · S/N 413-98

Back to AD 80-04-03 R2