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.

N623TCSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1998 · S/N 20023 N62494Pacific Fleet Aviation LLC · Rochester, NYBuilt 1976 · S/N 27-7654019 N62495Gentrys Flying Service LLC · Prattville, ALBuilt 1976 · S/N 277654020 N62498Hogan Michael J · Bonita Springs, FLBuilt 1975 · S/N 27-7654023 N6249JAkwari Aerospace LLC · Burbank, CABuilt 1976 · S/N 32R-7680340 N6249YPapagni Demetrio G · Madera, CAS/N 27-3487 N624DPHamons Spencer · Cookson, OKBuilt 1981 · S/N 32-8124033 N624GTTrue Lumen Aviation LLC · Grosse Pt Shr, MIBuilt 1978 · S/N 32R-7987041 N624MEPetry Christopher M · Frankfort, ILFirst renewal noticeBuilt 1969 · S/N 31-624 N62508Pacific Fleet Aviation LLC · Rochester, NYBuilt 1975 · S/N 27-7654029 N6253YMidwest Air LLC · Hartford, SDS/N 27-3491 N62546Kurtz Benjamin · Steamboat Springs, COBuilt 1999 · S/N T20608104 N62557Yukon Intermountain Inc · Anchorage, AKBuilt 1976 · S/N 27-7654037 N62564Del Mar College · Corpus Christi, TXBuilt 1976 · S/N 27-7654044 N6257YDavila Rudolfo G · Runge, TXS/N 27-3497 N6258XJ & S Aviation LLC · Fairview, OKBuilt 1961 · S/N 500B-1155-84 N62593Samco USA LLC · Reno, NVBuilt 1976 · S/N 27-7654071 N62599Raw Enterprises Inc · Lewes, DEBuilt 1976 · S/N 27-7654077 N6261LWoodward Aviation LLC · Alpine, TXBuilt 2004 · S/N T18208289 N6261RGray Joseph C · San Diego, CABuilt 2004 · S/N T18208290 N6261XLines Gary K · Glendale, AZBuilt 2004 · S/N T18208292 N62625Registration Pending · Buffalo, MNRegistration pendingBuilt 1976 · S/N 27-7654095 N6263JMcclain Family Cellars Inc DBA · Irvine, CABuilt 1976 · S/N 32R-7680344 N62647Pacific Fleet Aviation LLC · Rochester, NYBuilt 1976 · S/N 27-7654112 N62650Lpc Aviation Inc · Punta Gorda, FLBuilt 1976 · S/N 27-7654115 N62654Skylens LLC · Hammond, LABuilt 1976 · S/N 27-7654120 N62665Murvin Theoren J III · Winter Garden, FLBuilt 1976 · S/N 27-7654129 N62677Kersey Brian A · Pulaski, TNS/N 27-7654136 N6267KMill Boys Flying LLC · Wilmington, DES/N 477 N62688Blair Leonard · Fleetwood, PABuilt 1976 · S/N 27-7654144 N62697Edwards Benjamin F · La Canada, CABuilt 1976 · S/N 27-7654155 N62699Antelope Valley College · Lancaster, CAS/N 27-7654156 N6269YN6269y Six Place LLC · Miami, FLBuilt 1966 · S/N 27-3513 N626BFVenture North Aviation LLC · Cloquet, MNBuilt 1976 · S/N 27-7654108 N626DBJims Air LLC · Oconomowoc, WIBuilt 2004 · S/N T20608503 N626LSHollendonner Keith · Markleville, INBuilt 2005 · S/N T18208405 N626RNFerguson & Son Inc · Lebanon, TNBuilt 1967 · S/N 32-40246 N626SPJoye Robert M · Casa Grande, AZBuilt 1976 · S/N 27-7654094 N626VBJbo Airventures LLC · Saint Petersburg, FLBuilt 1995 · S/N 27-0197 N62707Registration Pending · Piedmont, SCRegistration pendingBuilt 1976 · S/N 27-7654163 N6273JLance J Piper LLC · Green Bay, WIBuilt 1976 · S/N 32R-7680346 N62756Red State LLC · Daytona Beach, FLBuilt 1976 · S/N 27-7654202 N627AXSky Ridge Transport LLC · Anaheim, CABuilt 2002 · S/N 4636341 N627DYColtov LLC · San Diego, CABuilt 1999 · S/N 4636247 N627JKUlrich Sandy J · Haskell, OKBuilt 1966 · S/N 27-3223 N627MADestination Alaska Air Service LLC · Homer, AKBuilt 1975 · S/N 31-7512055 N62801Pacific Fleet Aviation LLC · Rochester, NYBuilt 1976 · S/N 27-7754032 N62802Hannair LLC · Titusville, FLBuilt 1976 · S/N 27-7754033 N62807Neal Aircraft Inc · Slaton, TXBuilt 1976 · S/N 27-7754040 N62808Wings Over Texas Holdings LLC · Denton, TXS/N 27-7754041

Back to AD 81-12-06 R1