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.

N4983WPappa Whiskey Victor LLC · Brandon, MSBuilt 1977 · S/N 14303 N498MMLadd Air LLC · Mt Holly, NCS/N 4636149 N4995WAnderson Ryan L · Wadena, MNS/N 14315 N499FCFoxtrot Charlie Aviation LLC · Charlotte, NCBuilt 1976 · S/N 32R-7780076 N49BMHarriman Aviation LLC · Pearland, TXBuilt 1977 · S/N 27-7754077 N49DSSalinger David L · Verdi, NVBuilt 1998 · S/N 27-0251 N49FMRockin R&L Ranch · Kaufman, TXBuilt 1999 · S/N 27-0260 N49LBOwen Walter M · Arlington, TNBuilt 1976 · S/N 32R-7680481 N49RDDziak Chester · Jackson, MIBuilt 1966 · S/N 27-3192 N4AVSouthwest Aircraft LLC · Fairacres, NMBuilt 1949 · S/N NAV-4-1844 N4DRTotah John E · Kailua Kona, HIBuilt 1966 · S/N 27-3175 N4EPPilots Landing Aviation LLC · Lampasas, TXBuilt 1979 · S/N 70032 N4QSPonderosa Aviation LLC · Safford, AZBuilt 1968 · S/N 1755-1 N4SGCp Aero LLC · Missoula, MTBuilt 2002 · S/N 3257282 N4VSAircraft Montana LLC · Helena, MTBuilt 1974 · S/N 27-7405426 N4WBBe Positive Holdings LLC · Bloomsburg, PABuilt 1977 · S/N 32R-7880018 N5008AWings Like Eagles LLC · Wilmington, DES/N 27-3695 N500EGElliott Candice H Brown · Santa Rosa, CABuilt 1974 · S/N 27-7405453 N500GWFeldtman Enterprises Inc · Wilmington, DEBuilt 1964 · S/N 1476-170 N500HMTalos Aviation Group LLC · Blackstone, VABuilt 1973 · S/N 3155 N500HRDese Enterprises LLC · Huntsville, ALBuilt 1981 · S/N 318152133 N500LCCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1979 · S/N 27-7954060 N500QSanborn Map Co Inc · Colorado Springs, COBuilt 1973 · S/N 31-7300934 N500TDPacific Fleet Aviation LLC · Rochester, NYBuilt 1977 · S/N 27-7854027 N5014TGalati David R · Sebring, FLBuilt 1972 · S/N 32-7240098 N5015HKnox Fred · Los Altos, CABuilt 2001 · S/N T18208096 N501BCJamestown Jet Center Inc · Jamestown, NDBuilt 1973 · S/N 27-7305157 N501BTCloud Chasers LLC · Columbus, MSBuilt 1976 · S/N 32R-7780039 N5020ABrown Jonathan Corey · Sherman Oaks, CABuilt 2001 · S/N T18208097 N5033TJulol Investments LLC · Miami, FLBuilt 2005 · S/N T18208454 N503JALiem David H · Brea, CABuilt 1965 · S/N 24-4165 N503VFC&H Aviation LLC · Greenwood Village, COBuilt 2003 · S/N 3255004 N505HVHelivision LLC · Concord, NCBuilt 2000 · S/N T20608152 N505JWCampbell Matthew P · Visalia, CABuilt 1975 · S/N 75-31118 N5061CMatheny Robert Gregg · Kingman, AZBuilt 2002 · S/N T18208166 N5066HDohr William F · Williamsburg, VABuilt 2001 · S/N T18208098 N506CVail Jeffrey · Kennett Square, PABuilt 2004 · S/N 3255015 N506TMTall Timber Flying Service LLC · Kalispell, MTBuilt 2005 · S/N T20608585 N507JBDi Marco Michael G · Orlando, FLBuilt 1979 · S/N 27-7954051 N507MAAviation Consultants US Inc · Beaver Falls, PABuilt 2004 · S/N 3255014 N508ACKtaz Air LLC · Niceville, FLBuilt 2001 · S/N T18208012 N508YLally Michael M · Miami, FLBuilt 1969 · S/N 31-452 N50BFStephenson Keith · Studio City, CABuilt 2004 · S/N 4636355 N50CCScott Macdonald Aircraft Sales Inc · Stuart, FLBuilt 1974 · S/N 27-7405360 N50DJWest Chester Air LLC · West Chester, PABuilt 1981 · S/N 32-8124021 N50PSExecutive Airshares LLC · St Thomas, VIBuilt 1973 · S/N 31-7405165 N50RNOn Three Angels Wings LLC · Melbourne, FLBuilt 1983 · S/N 31P-8414013 N50VVVictor Victor Leasing LLC · Pompton Plains, NJBuilt 2004 · S/N T18208277 N5107YBrown Peter B · Salem, VABuilt 2001 · S/N T18208099 N510ADDj Aztec LLC · Springfield, OHBuilt 1980 · S/N 27-8054044

Back to AD 91-21-01 R1