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.

N60CGSaj Aviation LLC · Reading, PABuilt 1980 · S/N 318052206 N60GWBangert Computer Systems Inc · Shawnee, KSBuilt 1969 · S/N 60-0030 N60JJGauss Karl F · Tully, NYBuilt 1976 · S/N 14175 N60KSMay Phillip Edward · Florence, ALBuilt 1978 · S/N 60-0560-182 N60MBCurry Arnold J · Houston, TXBuilt 1966 · S/N 27-3544 N60TAAero Elite LLC · Springfield, MOS/N 31-7552094 N60TTOurhappyfamilyplane LLC · Mason, OHBuilt 1979 · S/N 32-7940151 N60VBVvs Implements LLC · Wilmington, DES/N 60-0182-080 N6106XAir Margarita Inc · San Juan, PRBuilt 1960 · S/N 500B-941-28 N610BWCentral Airlines Inc · Leawood, KSBuilt 1965 · S/N 1523-185 N610DBPvr Construction LLC · Wilmington, DEBuilt 2006 · S/N T18208504 N610LBWinters Jesse · New Braunfels, TXBuilt 1976 · S/N 32R-7680304 N610MAThomas Michael J · Malabar, FLBuilt 1966 · S/N 32-40105 N6114XHardy Gareth R · Thatcher, AZBuilt 1960 · S/N 500B-924-9 N6119VN6119v LLC · Boca Raton, FLBuilt 1995 · S/N 14629 N611ADValiair Lc Trustee · Casper, WYBuilt 2003 · S/N T18208196 N611DGMiller Stephen James · Shreveport, LABuilt 1993 · S/N 27-0156 N611DPInversiones Flg Inc · Dorado, PRBuilt 1977 · S/N 31-7812040 N611DWNav Solutions LLC · Lewes, DEBuilt 1961 · S/N 500B-1099-60 N611HMPhysical Systems Inc · Carson City, NVBuilt 1976 · S/N 61P-0290-069 N611WWCone S E Jr · Hobbs, NMBuilt 1978 · S/N 277854093 N6121AMichael Lancy Architect Inc · Glendora, CABuilt 1998 · S/N 20021 N6121YWeaver Scott Allen · North Logan, UTBuilt 1966 · S/N 27-3332 N6124MDiscovery Air LLC · Austin, TXBuilt 2000 · S/N 3257143 N6125YDelaware Aircraft Trust LLC Trustee · New Castle, DES/N 27-3336 N612JSWings Of Eagle LLC · Leo, INBuilt 1970 · S/N 32-40935 N612WWEhecatl LLC · Fort Wayne, INBuilt 1977 · S/N 27-7754114 N612XMexico Medical Missions · Missouri City, TXBuilt 2003 · S/N T18208202 N6137JBradford III Properties LLC · Huntersville, NCBuilt 1976 · S/N 32R-7680309 N6138JLockwood Elijah T · Dayton, OHBuilt 1976 · S/N 32R-7680310 N613DBTigner Steven M · Leesburg, FLBuilt 1999 · S/N 3257091 N613RAKampa Arnold J · Vero Beach, FLBuilt 1966 · S/N 27-3347 N613SMWiff Robert A · Tahuya, WABuilt 1981 · S/N 32R-8129034 N613WKKnaust Jerry L · Blue Jay, CABuilt 1966 · S/N 27-3344 N6140YSouthern Seaplane Inc · Belle Chasse, LAS/N 27-3353 N61430Arias Aviation Inc · Wilmington, DEBuilt 1974 · S/N 31-7401242 N61470White Jerald W DBA · Jackson, TNBuilt 1974 · S/N 31-7401262 N61490Wings Of Hope Inc · Chesterfield, MOBuilt 1975 · S/N 31-7512004 N6149YRobbins Warren N · Chandler, AZBuilt 1966 · S/N 27-3366 N614HMMuhlbach Robert A · Manhattan Beach, CABuilt 1976 · S/N 61P-0306-080 N614KFGreat Ledge Development Inc · Saint Louis, MOBuilt 1977 · S/N 31-7752136 N615HMHill Gerald A · Mesa, AZS/N 61P-0311-082 N615KEDesert & Delta Air LLC · San Francisco, CABuilt 2004 · S/N T20608464 N6161PTse Jeffrey R · Boulder, COBuilt 2005 · S/N T18208384 N6164XRandall Kyle T · Klamath Falls, ORS/N 500B-1012-33 N6164YStriplin James R Jr · Hartford, ALBuilt 1966 · S/N 27-3383 N6168HWayne Air LLC · Collinwood, TNBuilt 1977 · S/N 32R-7880046 N6169YWiesen Enterprises Ltd · Empire, MIBuilt 1966 · S/N 27-3317 N616JPWb Painting Contractors LLC · Greenville, MSBuilt 1967 · S/N 32-40420 N6170YGe Org Advanced Systems LLC · Newton, NJBuilt 1966 · S/N 27-3391

Back to AD 81-12-06 R1