Skip to content

Registered aircraft · 40,471

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.

N8274HThunderbird Aircraft Co · Bloomington, MNBuilt 1980 · S/N 28-8190052 N8274JHunt Tyson B · Saratoga Springs, NYBuilt 1979 · S/N VAC-120-79 N8274NJln Aviation Services LLC · Avon, INBuilt 1969 · S/N 28-25489 N8274WSleight Travis A · Southfield, MIBuilt 1965 · S/N 28-2429 N82750Jabour Virginia · Port Orange, FLBuilt 1980 · S/N 28-8116053 N82751Fly49 LLC · Palmer, AKBuilt 1977 · S/N 18-7709194 N82754Lee Nathan · Athol, IDBuilt 1977 · S/N 18-7709196 N82757Registration Pending · Fairmont, WVRegistration pendingBuilt 1980 · S/N 28-8116054 N8275JFlabob Airport LLC · Riverside, CABuilt 1979 · S/N VAC-121-79 N8275NRollinger Dennis P · Plainfield, ILBuilt 1969 · S/N 28-25490 N8275UStout Kerrick L · New Richmond, OHFirst renewal noticeBuilt 1979 · S/N 18-7909102 N82765Musumeci Paul N · Wilmington, DEBuilt 1980 · S/N 28-8190062 N8276ASt Cloud Technical & Community College · Saint Cloud, MNBuilt 1980 · S/N 44-8107023 N8276DMusko Richard · Plains, PABuilt 1958 · S/N TD-22 N8276ESkyview Aviation LLC · Tracy, CABuilt 1979 · S/N 17272163 N8276HDelalat Sean · San Diego, CABuilt 1980 · S/N 28-8116055 N8276JWiser Anthony J · Goodyear, AZBuilt 1979 · S/N VAC-122-79 N8276NShreffler Christine A · Ballwin, MOBuilt 1980 · S/N 28-8116056 N8276VNorthrop John B · Madison, WIBuilt 1980 · S/N 28-8190056 N8276WTreleven Alfred Herbert IV · Tacoma, WAS/N 28-2431 N8276XBnb LLC · Greenwich, CTBuilt 1980 · S/N 28-8190057 N8276ZPar Five Enterprises LLC · Columbus, OHBuilt 1980 · S/N 28-8190061 N82770O'Neil Chadwick P · Wells, MEBuilt 1975 · S/N 495 N82779Northeast Planes Aviation Inc · Laramie, WYBuilt 1980 · S/N 28-8190058 N82783Gulf Atlantic Airways Inc · Gainesville, FLBuilt 1980 · S/N 28-8116057 N8278EEquinoxx Flight Systems LLC · Lawrenceville, GABuilt 1979 · S/N 17272165 N8278NBastian Richard D · Chiloquin, ORBuilt 1969 · S/N 28-25493 N8278WChamberlain Mark S · Hamburg, NYBuilt 1965 · S/N 28-2434 N8279EHull Farms Inc · Blythe, CABuilt 1979 · S/N 17272166 N8279JRowland Blayne C Administrator · Raymondville, TXS/N VAC-125-79 N8279NWillson Michael S · Saint Cloud, FLBuilt 1969 · S/N 28-25495 N8279PRobinson Andrew T · South Windsor, CTS/N 1835 N827ATAviation Training LLC · Wilmington, DEBuilt 2002 · S/N 4496149 N827CTobin James M · Latrobe, PABuilt 2001 · S/N 81106 N827GBJohnson Douglas C · North Grafton, MABuilt 1998 · S/N 22394 N827GSFosha Kathryn · Tehachapi, CAS/N 23646 N827JHEisenmenger James P Trustee · Yankton, SDBuilt 1996 · S/N 2438 N827WTCsu Aviation LLC · Plainfield, INBuilt 1996 · S/N 1222-96 N8280NEllis Clifford J · Murray, KYBuilt 1969 · S/N 28-25496 N8280WGarbin Kurt A · Steamboat Springs, COBuilt 1965 · S/N 28-2437 N8281CThomas Ken C · Fairbanks, AKBuilt 1954 · S/N 18-3689 N8281JJudy Gregory K · Hudson Oaks, TXBuilt 1979 · S/N VAC-127-79 N8281NTan Dexter E · Dallas, TXS/N 28-25497 N8281WNeisen Brandon L · Fowler, ILBuilt 1965 · S/N 28-2438 N8282JHoover Michael B · Ridgeland, WIBuilt 1979 · S/N VAC-128-79 N8282VEnsemble Air LLC · Laramie, WYBuilt 1980 · S/N 28-8116060 N8282WBenker Albert J · Bevier, MOBuilt 1965 · S/N 28-2440 N82832Stokke Todd · Magnolia, TXBuilt 1980 · S/N 28-8190066 N82836Aerodreams Aviation LLC · Raleigh, NCBuilt 1980 · S/N 28-8190071 N8283JFurey Gale J · Bedford, NHBuilt 1979 · S/N VAC-129-79

Back to AD 80-04-03 R2