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.

N70TLAltitude Adjusters LLC · Cranford, NJBuilt 1965 · S/N 27-2797 N710JPSt Matthew Aviation Company LLC · Kalispell, MTBuilt 1979 · S/N 31-7952086 N710KVG B Aerial Applications Inc · Slaton, TXS/N T18208291 N710SMExclusive Aeronautics LLC · Las Vegas, NVBuilt 1994 · S/N 27-0174 N711BAPresley Louis · Cresson, TXBuilt 1968 · S/N 24-4801 N711BWQualitair LLC Trustee · MichelstadtBuilt 1969 · S/N 24-4877 N711JLCentral Iowa Agricultural Aviation LLC · Wellsburg, IABuilt 1973 · S/N 32-7340175 N711LYSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2003 · S/N 2182 N711PFTaylor Monty · Kingfisher, OKS/N 32-7340061 N711WZBaker Matthew · Mesa, AZBuilt 1990 · S/N 27-0042 N712PWDown The Creek LLC · Grant Valkaria, FLBuilt 1976 · S/N 32R-7680276 N7139CGv Air Inc · Medford, ORBuilt 1969 · S/N 31-553 N713ECCharlie Tango LLC · Mechanicsville, VABuilt 1975 · S/N 27-7554151 N713HMPinto Carlos · Tucson, AZBuilt 1977 · S/N 61P-0449-172 N713WTWtw Air LLC · Houston, TXBuilt 1977 · S/N 31-7752138 N714KLMatera Management LLC · Spanish Fork, UTBuilt 2002 · S/N 4636328 N715BBMartin L Jeffrey · Hudson, OHBuilt 1996 · S/N 4636038 N715LGGuy Transportation Ltd · Carolina, PRS/N 500B-1174-90 N715LMIntepros Inc · Jupiter, FLBuilt 1998 · S/N 4636173 N7164DAir Arctic Inc · Fairbanks, AKBuilt 1980 · S/N 31-8052013 N716PRChupond America Inc · Pittstown, NJBuilt 2000 · S/N 27-0305 N716SBDirect Gulf Access LLC · Springfield, MOBuilt 1978 · S/N 32R-7987088 N716TCCentral Airlines Inc · Leawood, KSBuilt 1962 · S/N 500B-1225-102 N717GMAlbatross Aviation LLC · Tazewell, TNBuilt 1997 · S/N 46-36118 N717MZMaritz Paul · Mercer Island, WABuilt 1999 · S/N T20608090 N717SKLava Rock Properties LLC · Saint George, UTS/N 4636053 N717UOcean Abaco LLC · Virginia Beach, VABuilt 1983 · S/N 31-8352026 N719PFuhr David · Wabasso, MNBuilt 1968 · S/N 31-272 N71CEMcgowan Chad · Rock Hill, SCBuilt 2004 · S/N T18208278 N71DPDjp Enterprises Inc · Chandler, TXBuilt 2001 · S/N T18208056 N71FLWest Transportation LLC · West Bloomfield, MIBuilt 1968 · S/N 27-3969 N71JGFred Garrison Oil Co · Plainview, TXBuilt 1970 · S/N 61-0057-106 N71WZArlington Aviation Inc Trustee · Wilmington, DEBuilt 2000 · S/N 4636275 N7204CHousley Communications Inc · San Angelo, TXBuilt 1975 · S/N 32R-7680042 N720JBSchoettle Steve P · Heber Springs, ARBuilt 1979 · S/N 32-7940150 N720KMTrubee Jay G Trustee · Palm Desert, CABuilt 2002 · S/N 3257300 N720WDThorntons Aircraft LLC · Tuscaloosa, ALBuilt 2003 · S/N 3257327 N721CEErtel Thomas H · Charlotte, NCBuilt 1980 · S/N 31-8112002 N722AVMcdaniel Ibarra Professional Services Inc · Palm Desert, CABuilt 1976 · S/N 32R-7780029 N722CZThree D Adventures LLC · Newfolden, MNBuilt 1999 · S/N T20608118 N722ETSymonds Stephen M · Colleyville, TXBuilt 1996 · S/N 4636047 N722LWWineberg Lindsay · Beverly Hills, CABuilt 1976 · S/N 14062 N722RMFisher Mark A · Leola, PABuilt 1974 · S/N 32-7440140 N722TTNext Gen Aviation LLC · Jenks, OKBuilt 1976 · S/N 60-0285-108 N7234CConfidential LLC · Lutz, FLBuilt 1975 · S/N 32R-7680043 N723KYCommonwealth Of Kentucky · Frankfort, KYBuilt 1978 · S/N 31-7852122 N724ATH Squared Aviation LLC · Sheridan, WYBuilt 1984 · S/N 32R-8429027 N724WRichard A Klie · Edwardsville, ILS/N 27-0338 N7256DAir Supremacy LLC · Bend, ORBuilt 1999 · S/N T20608068 N72582Surdex Corp · Chesterfield, MOFirst renewal noticeBuilt 1999 · S/N T20608114

Back to AD 81-12-06 R1