Skip to content

Registered aircraft · 20,481

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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.

N5257ASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2009 · S/N 18282181 N5257EWings 4 Paws LLC · Yulee, FLBuilt 1983 · S/N 18268304 N5257NAmanda Air Inc · Talladega, ALBuilt 1980 · S/N 18267606 N52587Mcconal Danny · Seminole, TXBuilt 1973 · S/N 18262690 N5258NOffcourt Ltd · Del Mar, CABuilt 1980 · S/N 18267607 N52590Aereo Flyers Inc · Camino, CABuilt 1973 · S/N 18262692 N52595Cotton Christopher S · Dallas, TXBuilt 1973 · S/N 18262696 N5259ECole Charles · Las Vegas, NVBuilt 1959 · S/N 50559 N525AGNoland Ronald E · Weston, ORS/N 51986 N525KWFuller Thomas R · Scottsdale, AZBuilt 1975 · S/N 21060881 N525LRSkywalker Leasing LLC · Wilmington, DEBuilt 1980 · S/N 18267356 N525XHarvey Thomas H · Novi, MIBuilt 1963 · S/N 206-0013 N52607Jse Holdings Inc · Wilmington, DEBuilt 1973 · S/N 18262705 N52608Kaliebe Kyle D · Mount Pleasant, WIBuilt 1973 · S/N 18262706 N5260AN5260a LLC · Los Angeles, CAS/N 21063333 N5260NBates Management Inc · Woodstock, GAS/N 18267609 N52617Land And Sky LLC · Buffalo, MNBuilt 1973 · S/N 18262715 N5261NCrowe Bradley Allen · North Chelmsford, MABuilt 1980 · S/N 18267610 N52620High Risk Ventures Inc · San Diego, CABuilt 1973 · S/N 18262718 N52621Bottieri David P · Mission Viejo, CABuilt 1973 · S/N 18262719 N52624Shrewsbury Roy E II · Daniels, WVBuilt 1973 · S/N 18262721 N52629Mbr Air LLC · Kenosha, WIBuilt 1973 · S/N 18262726 N5263VMccullough James M · Monte Vista, COBuilt 1975 · S/N 21060883 N5264CCullum Transportation LLC · North Charleston, SCBuilt 1979 · S/N 21063725 N52674Miller Glenn E Trustee · Albany, ORBuilt 1973 · S/N 18262760 N52677Spencer Joseph T Jr · Felton, CAS/N 18262763 N5267HNichani Nikhil Deepak · Livingston, NJBuilt 1981 · S/N 18267864 N5267SAviation Psych LLC · Neptune Beach, FLBuilt 1980 · S/N R18201530 N5267VN5267v LLC · Northbrook, ILBuilt 1975 · S/N 21060886 N52681Clough Robert · Woodinville, WABuilt 1973 · S/N 18262766 N52687Abby Enterprises LLC · Plantsville, CTBuilt 1973 · S/N 18262770 N52689Dyberg Mike DBA · Mount Vernon, WABuilt 1973 · S/N 18262771 N52694Sullivan Michael E Trustee · Granite Bay, CABuilt 2002 · S/N 18281161 N52698Marshall Gregory · Farmington, MEBuilt 1973 · S/N 18262779 N5269ERocky Pointe Logistics LLC · Hayden, IDBuilt 1959 · S/N 50569 N5269SCanyon Blue LLC · Sharpsburg, GABuilt 1980 · S/N R18201531 N526BLWarren Flying Club Inc · Troy, MIBuilt 1998 · S/N 18280132 N526LTCheatum Roger K · Port Orange, FLBuilt 1975 · S/N 18264197 N526MPS Brown Inc · Durant, OKBuilt 1965 · S/N 21058630 N526PLEdson Aviation Group LLC · Jericho, VTBuilt 1959 · S/N 50562 N526UJsrs Holdings LLC · Las Cruces, NMBuilt 1973 · S/N 18262708 N526VBGilbert Benjamin N Trustee · Chico, CABuilt 1977 · S/N 18265954 N52704Owen John D Trustee · Liberty, MOBuilt 1974 · S/N 18262782 N52707Mook Douglas G · El Paso, TXBuilt 1974 · S/N 18262785 N5270DGibson Brenton D · Siletz, ORBuilt 1957 · S/N 50168 N52714Greager William E · Lakewood, COBuilt 1974 · S/N 18262791 N52726Cottonwood Flyers LLC · Gypsum, COBuilt 1974 · S/N 18262800 N52727Nathaniel Mothershead · Sardis, MSBuilt 1974 · S/N 18262801 N5272UAerial Surveys Inc · Conway, ARBuilt 1964 · S/N 206-0272 N52732Registered aircraftBuilt 1974 · S/N 18262804

Back to AD 84-10-01 R1