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.

N122AWAztec Worldwide Airlines Inc · Wilmington, DEBuilt 1976 · S/N 31-7652135 N122JPZatika Francis · Bridgewater, NJBuilt 1978 · S/N 61P-0535227 N122MENorton Mark Trustee · Stateline, NVBuilt 2000 · S/N T20608153 N122TEBouchillon James R · Hanahan, SCBuilt 1972 · S/N 32-7340044 N123ALLambert Danny J · Plainview, TXBuilt 1973 · S/N 73-32-104 N123BBSingletrack Aviation LLC · Brecksville, OHBuilt 1996 · S/N 27-0220 N123BEBald Moutain Aviators · Fredericktown, MOBuilt 1967 · S/N 32-40271 N123GHMoyers Jeff · Troy, VABuilt 2002 · S/N T18208105 N123KCHelms Brandon M · Indian Trail, NCBuilt 1976 · S/N 32R-7680431 N123KW123 LLC · Allentown, PABuilt 1968 · S/N 31-198 N123LMMccleary Bryan W · Marion, OHBuilt 1967 · S/N 24-4669 N123PTScheller Erik G Trustee · Gig Harbor, WAS/N 31-8112020 N123PVSandlapper Aviation Of De Inc · Bennington, VTBuilt 1973 · S/N 27-7305039 N123RMConstruction Imports LLC · Fleetwood, NCBuilt 1996 · S/N 27-0221 N123TEVirgil W Young Jr Pa · North Little Rock, ARBuilt 1994 · S/N 4622169 N124AGPegasus Enterprises LLC · Granbury, TXBuilt 1978 · S/N 31-7852103 N124KYMozzie Air LLC · Tampa, FLBuilt 2005 · S/N T18208453 N124WABraswell Jerrold W · Dillingham, AKS/N 31-7405242 N1258QSiner John R · Kingsport, TNBuilt 1999 · S/N 4636191 N12595Cornell Terry Jason · Bloomsburg, PABuilt 1971 · S/N 27-4725 N125AHPray Ricky Lee Trustee · Woodland Hills, UTS/N T18208240 N125AKBaize Equipment LLC · Crawford, TXBuilt 2004 · S/N T18208320 N125SEDyer John F · Spring, TXBuilt 1969 · S/N 61-0027 N125WWKapotes Nicholas Stephan · Pompton Plains, NJBuilt 1998 · S/N 18280348 N126CAFeltmann Dean A · North Charleston, SCBuilt 1974 · S/N P-257 N126DRForbis Michael · Calera, OKBuilt 1974 · S/N 31-7405173 N126HJPeterson Charles William · Midway City, CABuilt 1969 · S/N 24-4878 N126LMMatt Aviation Propertis Inc · Nashua, NHBuilt 2003 · S/N 3257336 N126PCRoots & Wings Aviation LLC · West Simsbury, CTBuilt 1979 · S/N 32R-8029042 N126PKPtk Equipment Inc · Miami Lakes, FLBuilt 2005 · S/N 3257390 N1275RHatter Dan D · Dumas, TXBuilt 1971 · S/N 32-53 N127GT7 Golf Tango LLC · Saint Petersburg, FLBuilt 2004 · S/N 3257343 N127KHCentral Airlines Inc · Overland Park, KSBuilt 1961 · S/N 500B-1027-38 N1285ROrbit Aviation LLC · Lakewood, CAS/N 31026 N1287TBelle Casa Aero LLC · Tarpon Springs, FLBuilt 1972 · S/N 32-7240111 N128AGarza Family LLC · Helena, MTBuilt 1967 · S/N 32-40354 N128MGHastings Gladstone E · Miramar, FLS/N 31-7712074 N128WPPatterson Weldon E · Maryville, TNBuilt 1969 · S/N 32-40579 N1297TReich David W · Fort Lauderdale, FLBuilt 1972 · S/N 32-7240112 N129BBLawson Michael · Englewood, TNBuilt 1969 · S/N 31-481 N129MBYellowfin Air Services LLC · Wilmington, DEBuilt 1971 · S/N 3108 N129RCAirris Aviation & Marine Co · N Fort Myers, FLBuilt 1993 · S/N 27-0173 N12BHMunk-Ee Business Aviation LLC · Linden, MIBuilt 1956 · S/N 157-195 N12GEJ&P Master Flooring Corp · Lauderdale Lakes, FLBuilt 1974 · S/N 27-7405422 N12KWAllied Moulded Products Inc · Bryan, OHBuilt 2000 · S/N 4636255 N12LVR2b2 Enterprises Lllp · Weldon Spring, MOBuilt 1975 · S/N 61-0238-099 N12STWise Ventures LLC · Mooresville, NCBuilt 2006 · S/N 3257412 N12TZJ H O Enterprises Inc · Carol Stream, ILS/N 61-0259-101 N12WZNortech Data Services Inc · Wilmington, DEBuilt 2003 · S/N 2206 N12XLAurora Aviation LLC · Billings, MTBuilt 2004 · S/N 27-0325

Back to AD 81-12-06 R1