Skip to content

Registered aircraft · 5,102

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-12-06-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-12-06-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-12-06-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-12-06-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-12-06-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-12-06-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.

N5354VHowe Andrew · Wshngtn Xing, PABuilt 2002 · S/N 3257298 N5358FAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2003 · S/N 3257312 N53592Gulfstream Design Associates Inc · Delray Beach, FLBuilt 2003 · S/N 3257317 N5359YMajeste Air LLC · Loveland, COBuilt 1963 · S/N 27-2432 N535CAHanson Robert M · Riverside, CABuilt 1977 · S/N 14293 N5363QCary Gosney Crna Inc · Sonora, CABuilt 2003 · S/N T18208203 N53668Xtra Aviation LLC · Redwood City, CABuilt 2003 · S/N 3255009 N5367JAir Prescher Airline Limited · Lake Havasu, AZBuilt 2003 · S/N 3257320 N53682Fisher Bryce D H · Holly Springs, NCBuilt 2003 · S/N 3257323 N53685Aircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2003 · S/N 3255008 N5369JMjr Aviation LLC · Boulder Creek, CABuilt 2003 · S/N 3255013 N536DDHughes Jacob · Denver, COBuilt 2004 · S/N T18208317 N536SAMx Leader LLC · Monterey, CABuilt 1973 · S/N 3169 N536SBKilo One LLC · Saint Petersburg, FLBuilt 1996 · S/N 4636048 N5381TBlaes Christopher T · Gallatin, TNBuilt 1972 · S/N 32-7240106 N5382FRose James A · Boston, MABuilt 1976 · S/N 32R-7680520 N5382NHarrell Thomas · Ocala, FLBuilt 1982 · S/N 32-8224012 N538SBBurroughs Scott · Raleigh, NCBuilt 2000 · S/N 3257174 N5390FHeights Flight Management LLC · Monroeville, NJBuilt 1976 · S/N 32R-7680522 N5391YHeartland Aviation Inc · Alliance, NEBuilt 1963 · S/N 27-2467 N53LJJessen Larry S · Damascus, ORBuilt 2023 · S/N LIV-500 N54004Sobey Peter L · Aurora, OHBuilt 1974 · S/N 27-7405354 N54072Dewitt Gary D · Encinitas, CABuilt 1974 · S/N 27-7405382 N54075Pilot Pros Inc · Miami, FLBuilt 1974 · S/N 27-7405385 N54077Geo Mar Co Aviation Ltd · Clyde, OHBuilt 1974 · S/N 27-7405389 N54089Island Birds Inc · St Thomas, VIBuilt 1974 · S/N 27-7405390 N54092Harper-Smith Michael · Tarzana, CABuilt 1974 · S/N 27-7405405 N54097Piper Nia 1 LLC · Doylestown, PABuilt 1974 · S/N 27-7405408 N540PSteenrod Kenneth A · Parsons, KSS/N 31-65 N540WBAirmart Aircraft Holdings Inc · Oak Ridge, NCBuilt 2002 · S/N 3257269 N54109Gilmores Glorious Goods LLC · Lewes, DEBuilt 1974 · S/N 27-7405421 N5411FMack Robert A · Brighton, COBuilt 1976 · S/N 32R-7780003 N54155Aerospace Trust Management LLC Trustee · Wilmington, DES/N 27-7405452 N54195Decruz Peter John · Hattiesburg, MSBuilt 1974 · S/N 27-7405472 N54198Valiair Lc Trustee · Casper, WYS/N 27-7405474 N541BPEdge Aircraft LLC · Denver, COBuilt 1999 · S/N 3257087 N541VBCartier John · Cumberland, RIBuilt 2003 · S/N 3257334 N54221Emission-Air Inc · Lexington, NCBuilt 1974 · S/N 27-7554014 N54224Coosa Air LLC · Rome, GABuilt 1974 · S/N 27-7554017 N54225Jpr Capital LLC · San Juan, PRBuilt 1974 · S/N 27-7554018 N54236B & R Aircraft LLC · Wadsworth, OHBuilt 1974 · S/N 27-7554030 N54238Backcreek Farms Inc · Rougemont, NCBuilt 1974 · S/N 27-7554032 N54240Pacific Fleet Aviation LLC · Rochester, NYBuilt 1974 · S/N 27-7554034 N54245Pacific Fleet Aviation LLC · Rochester, NYBuilt 1974 · S/N 27-7554039 N5424DCarpenter Michael H · Mooresville, NCS/N 20028 N54258Nesbeda Peter J · Marlborough, NHBuilt 1974 · S/N 27-7554046 N543133seaslal LLC · Lakeland, FLBuilt 1974 · S/N 31-7405439 N5431FSea Container Sales Inc · New Waverly, TXBuilt 1976 · S/N 32-7740004 N5431YThompson Sherrel L · Pembroke Pines, FLBuilt 1964 · S/N 27-2508 N5432FHornish Thomas L · Malinta, OHBuilt 1976 · S/N 32R-7780007

Back to AD 81-12-06 R1