Skip to content

Registered aircraft · 25,369

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.

N824MAE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 1981 · S/N P21000763 N824MMRelevant Enterprises Inc · Kalispell, MTBuilt 1977 · S/N 24-0352 N824SGAudenaert William N · Madison, ALBuilt 2009 · S/N 1082-2009 N8253GHudson Allen N · Bowling Green, KYS/N 177RG0153 N8255GCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1971 · S/N 177RG0155 N8259GCappello Dave Allen · Cottonwood, CAS/N 17273619 N825DSBreckner Robert J · Burnsville, MNBuilt 2014 · S/N 1471-2014 N825ERFlying Aces Aero-Fleet Inc · Guyton, GABuilt 1977 · S/N 17269484 N825MCC & M Aviation LLC · White Lake, MIBuilt 1976 · S/N 1154-76 N825RHNorthcutt Randy · Alpine, WYBuilt 2013 · S/N 559-2013 N825TMHigher Plane LLC · Las Vegas, NVBuilt 1982 · S/N 24-1300 N8261GBaer Charles · Terre Haute, INBuilt 1971 · S/N 177RG0161 N8262GRegistration Pending · Hampshire, ILRegistration pendingBuilt 1973 · S/N 18801274 N8265GYencarelli Mark S · Riverview, FLS/N 177RG0165 N8266EPropel Air LLC · Pottstown, PABuilt 1979 · S/N 17272156 N8266GBode Todd D · Brush Prairie, WABuilt 1971 · S/N 177RG0166 N82671Keleman Kenneth S · Bellingham, WABuilt 1976 · S/N 17266998 N82682Long Jory J · Lake Ozark, MOBuilt 1970 · S/N 772-70 N8268ERegistration Pending · Richlands, NCRegistration pending, pending cancellationBuilt 1979 · S/N 17272158 N8269EBucher Max · Fort Mohave, AZS/N 17272159 N826CVScott Roger A · Saint Croix Falls, WIBuilt 1979 · S/N R18201128 N8271GCantrell Dean P · Greenwood, INBuilt 1971 · S/N 177RG0171 N8274EChristiansen Aviation LLC · Wilmington, DEBuilt 1979 · S/N 17272161 N8274GMorris Robert B · Star Valley, AZBuilt 1971 · S/N 177RG0174 N8276ESkyview Aviation LLC · Tracy, CABuilt 1979 · S/N 17272163 N8277GCountry Aero LLC · Darwin, MNBuilt 1973 · S/N 18801281T N8278EEquinoxx Flight Systems LLC · Lawrenceville, GABuilt 1979 · S/N 17272165 N8279EHull Farms Inc · Blythe, CABuilt 1979 · S/N 17272166 N827GLEtchart Joseph O · Glasgow, MTBuilt 1978 · S/N 0827 N827LBCapital Consulting LLC · Newport Beach, CABuilt 1979 · S/N R18201006 N827RPJireh Aviation LLC · Zeeland, MIBuilt 1980 · S/N P21000541 N827WTCsu Aviation LLC · Plainfield, INBuilt 1996 · S/N 1222-96 N8281EAir Plains Services Corp · Wellington, KSBuilt 1979 · S/N 17272168 N8281GWidtfeldt John R · Auburn, PABuilt 1971 · S/N 177RG0181 N8285EJames G Loy General Contractor Inc · Punta Gorda, FLBuilt 1979 · S/N 17272171 N8286EPreston Richard R Trustee · Albuquerque, NMBuilt 1979 · S/N 17272172 N8288EGomez Cierra D · Jasper, ALS/N 17272174 N8288GFord Flying Service Inc · Doerun, GABuilt 1973 · S/N 18801287 N8289GDutcher Kenneth J · Kingsland, TXS/N 177RG0189 N828BCFitzdam Justin D · Franklin, TNBuilt 1979 · S/N R18200975 N828DPZepponi Dan · Napa, CABuilt 1983 · S/N 24-1348 N828JTAtems Elisabeth · Northfield, VTBuilt 1976 · S/N 177RG0945 N828RJNielsen Ron E · Lindon, UTS/N 21063836 N828YLong Island Aviators LLC · Seaford, NYBuilt 1976 · S/N 17268168 N8291ERangers Flying Club Inc · Eden Prairie, MNBuilt 1979 · S/N 17272177 N8291GBullock Brooks M II · Cartersville, GABuilt 1971 · S/N 177RG0191 N8292EP&N Corp · Marion, IAS/N 17272178 N8293EFiorini Anthony Wayne · Tuttle, OKBuilt 1979 · S/N 17272179 N8293RPanterra Aviation LLC · Mountain Green, UTBuilt 1979 · S/N R18200933 N8295EFrump Leasing Inc · Newburgh Heights, OHS/N 17272181

Back to AD 80-25-07 R1