Skip to content

Registered aircraft · 4,000

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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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.

N12HWMoonfly Inc Trustee · Wilmington, DEBuilt 1981 · S/N 25-0557 N12JIsland Aviators LLC · Grosse Ile, MIBuilt 1977 · S/N R1722455 N12PJLarrabee Joey S Trustee · Holyoke, COBuilt 1979 · S/N 28R-7931105 N13030Miller Tim D · Seymour, MOBuilt 1967 · S/N R1720239 N130MBAirdale Aviation LLC · Glade Hill, VABuilt 2005 · S/N 1516 N130PScreaming Eagle Tactical Aerial Spraying LLC · Bell Buckle, TNBuilt 2010 · S/N 80810 N1311LCarpe Diem Atb LLC · Northfield, MNS/N 33701804 N1312LMccole Kevin · Brookline, NHBuilt 1977 · S/N 33701805 N1318HEvern Properties LLC · Kalispell, MTS/N 28R-7703022 N1319LOttlinger Robert L · Ormond Beach, FLBuilt 1977 · S/N 33701811 N131CDSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2000 · S/N 1031 N131EGEdgo Flying Inc · Naperville, ILBuilt 2002 · S/N 1248 N1324VTeton Leasing LLC · Pocatello, IDBuilt 1976 · S/N R1722161 N1325VColorado Northwestern Community College · Rangely, COBuilt 1976 · S/N R1722162 N1326VSaulit Christopher O · San Leandro, CABuilt 1976 · S/N R1722163 N1329VChadwick Garry Trustee · Cheyenne, WYBuilt 1976 · S/N R1722165 N132CTHanger Six LLC · Birmingham, ALBuilt 1978 · S/N 34-7870179 N132TTN132tt Inc · Los Angeles, CABuilt 2002 · S/N 1196 N1330VV1 Aeronautics LLC · Boise, IDBuilt 1976 · S/N R1722166 N1334HPreskar Michael H · Ione, CABuilt 1977 · S/N 34-7770121 N1335WCastanon Salvador L · Rancho Cucamonga, CABuilt 1963 · S/N 223 N1337LAviation Specialty Services LLC · Beaufort, NCBuilt 1977 · S/N 33701829 N1338V38 Victor LLC · Port Clinton, OHBuilt 1976 · S/N R1722172 N133CDQualitair LLC Trustee · MichelstadtBuilt 2000 · S/N 1025 N133NDHitch-Nel Partners LLC · Issaquah, WABuilt 1975 · S/N 33701669 N133SMSpivack Peter · Philadelphia, PABuilt 1979 · S/N 25-0001 N1348VBlake Joseph A · Jacksonville, FLBuilt 1976 · S/N R1722176 N134DSDoge Aircraft LLC · Boca Raton, FLBuilt 1982 · S/N 348233148 N134MGCsa Aircraft Leasing LLC · Salt Lake City, UTBuilt 1981 · S/N 34-8233007 N1350VCranor John David III · Fort Collins, COBuilt 1976 · S/N R1722178 N1352VAdventist World Aviation · Wilson, NCBuilt 1976 · S/N R1722179 N1353LAviation Specialty Services LLC · Beaufort, NCBuilt 1978 · S/N 33701845 N135DGSg Solutions LLC · Reno, NVBuilt 1977 · S/N 28R-7803122 N1360LKoukol Orin Trustee · Sacramento, CABuilt 1978 · S/N 33701852 N1365LKropp Christian Trustee · Azle, TXS/N 33701857 N13673Lande Michael D · Grand Marais, MNBuilt 1974 · S/N 17262932 N1375LAviation Specialty Services LLC · Beaufort, NCBuilt 1978 · S/N 33701867 N137CBEdmiston Brandon L · Murray, KYBuilt 1967 · S/N R1720146 N137MCPoland Gilbert Guardian · Dothan, ALBuilt 1965 · S/N 337-0127 N1384LCo Fire Aviation Leasing Inc · Fort Morgan, COBuilt 1978 · S/N 33701876 N1385LWhiskey River Aviation LLC · Medford, ORBuilt 1978 · S/N 33701877 N1390LGreen Rose LLC · Swartz Creek, MIBuilt 1978 · S/N 33701882 N139YPSmuzzle Air LLC · Longboat, FLBuilt 1977 · S/N 28R-7703364 N13AGWeather Modification LLC · Fargo, NDBuilt 1977 · S/N 34-7770115 N13EFMcgough Julie Eileen · Red Oak, TXBuilt 1967 · S/N 337-0794 N13KLN13kl LLC · Lewes, DEBuilt 2003 · S/N 3301 N13LMTupelo Limited Lc · Lake Charles, LAS/N 34-7870075 N1411VForbes David · Garden Grove, CABuilt 1976 · S/N R1722186 N1413VMercury International LLC · Cheyenne, WYS/N R1722187 N1416VRegistered aircraftBuilt 1976 · S/N R1722188

Back to AD 81-13-10 R1