Skip to content

Registered aircraft · 40,472

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.

N2604LE W Eaken & Co LLC · Columbiana, OHBuilt 1983 · S/N 0331 N26052Registration Pending · Bloomington, INRegistration pendingBuilt 1977 · S/N AA5A0407 N2605WHarman David M · Ballwin, MOBuilt 1965 · S/N 3287 N26069Alliance Flyers Inc · Haslet, TXBuilt 1977 · S/N AA5A0412 N26071Byrd Blake L · Southlake, TXBuilt 1977 · S/N AA5A0413 N26076Stevens Vincent T Pc · Ogden, UTBuilt 1977 · S/N AA5A0415 N26078Rearick Donald K · Clymer, PABuilt 1977 · S/N AA5A0417 N2607PFattrusso Louis Anthony · South Chesterfield, VAS/N 22-2942 N2607YAero-Sphere Inc · Longmont, COBuilt 1985 · S/N 28-8516086 N26082Hunt Edmond L · Madison, WVBuilt 1977 · S/N AA5A0420 N26086Joe Hoerter LLC · Hilton Head Island, SCBuilt 1977 · S/N AA5A0326 N26087Enger Kenneth H · Mesa, AZBuilt 1977 · S/N AA5A0421 N26094Hall George M · Blooming Grove, TXBuilt 1977 · S/N AA5A0422 N26098Chaput Armand J · Austin, TXBuilt 1977 · S/N AA5A0423 N260NDPlane Nonsense Inc · Middletown, DEBuilt 1999 · S/N 2842055 N260RJHitterman James D · Metropolis, ILBuilt 1982 · S/N 1 N26100Carey International Aviation Services LLC · Rockville Centre, NYBuilt 1977 · S/N AA5A0424 N26103Williams Richard · Atlanta, GABuilt 1977 · S/N AA5A0426 N26104Sumner Gary W · Knoxville, TNBuilt 1977 · S/N AA5A0402 N26106Polymer Depot LLC · Delafield, WIBuilt 1977 · S/N AA5A0427 N26114Flyinisme LLC · Saint Augustine, FLBuilt 1977 · S/N AA5A0433 N26116Fasske Wayne · Crossville, TNBuilt 1977 · S/N AA5A0437 N26120Houk David A Jr · Norton, OHBuilt 1977 · S/N AA5A0441 N26122Smile Givers · Chico, CABuilt 1977 · S/N AA5A0443 N26124Chapman Edward J DBA · Jordan, MNBuilt 1977 · S/N AA5A0444 N26127Rose David Alan · Port Orange, FLBuilt 1977 · S/N AA5A0446 N2612ZStewart Jon L · Walker, MNBuilt 1977 · S/N 1002-77 N26130Bokkers Maike L · Mountain View, CABuilt 1977 · S/N AA5A0447 N26132Active Pilot Solutions Inc · Van Nuys, CABuilt 1975 · S/N 28-7515443 N26136Aoki Nidal · Porter, TXBuilt 1977 · S/N AA5A0452 N2613PBraun Daniel R · Damascus, ORS/N 22-2948 N26142Stamper George William III · Quinton, VABuilt 1977 · S/N AA5A0454 N2614DRegistration Pending · Kerrville, TXRegistration pendingBuilt 1987 · S/N 0727 N2615WSturgis Joel B · Pensacola, FLBuilt 1965 · S/N 3292 N26160Wilson William J · Houston, TXBuilt 1977 · S/N AA5A0455 N26163Brown Michael D · Elk Grove, CABuilt 1977 · S/N AA5A0456 N26165Moldt Richard W · Montrose, CAS/N AA5A0457 N26167Mowery Ronnie G · Spencer, OHBuilt 1977 · S/N AA5A0461 N26172Flying Tigers Flight School Ltd · Houston, TXBuilt 1977 · S/N AA5A0465 N26179Richardson James D II · Bend, ORBuilt 1977 · S/N AA5A0468 N2617QKerhulas Anthony B · Santa Maria, CABuilt 1969 · S/N 17258707 N2617ZCroy Branden J · Kendallville, INBuilt 2001 · S/N 1301 N2618PHenningson Terry · Centennial, COBuilt 1955 · S/N 22-2954 N2619DInman Steve · Billings, MTBuilt 1952 · S/N 20771 N2619PColdsmith Steven L · Chambersburg, PABuilt 1955 · S/N 22-2955 N261DMOelmann Dennis J · Waverly, IAS/N 379 N261FCVu Ai · Aiea, HIBuilt 1968 · S/N 28-24697 N261HHoward Clifford E · Auburn, WABuilt 1968 · S/N R.E.C.2 N261XEvans Dennis · Naples, FLBuilt 2000 · S/N 60239 N26206Breakey Phillip · Pickerington, OHBuilt 1977 · S/N AA5A0471

Back to AD 80-04-03 R2