Registered aircraft · 5,086

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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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.

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 N130SJAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1999 · S/N T20608130 N130XRM&A Adams Family Lp · Mckinney, TXS/N 32R-7887003

Back to AD 91-21-01 R1