Registered aircraft · 1,827

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:90-06-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-13') 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:90-06-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-13')
  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:90-06-13')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-13')
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.

N194YYTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1989 · S/N FA-194 N195ALJmds Lift LLC · Helena, MTFirst renewal noticeBuilt 1986 · S/N FA-102 N1966JJetz Service Co Inc · Topeka, KSS/N 560-0802 N1967GGary Ventures Inc · Denver, COBuilt 2003 · S/N 5600641 N1969JRegistered aircraftBuilt 1994 · S/N 560-0277 N196ZZTj Air Holdings Inc Trustee · Wilmington, DES/N FA-196 N197PRGoodnights Spruce Goose LLC · Harmony, NCBuilt 1992 · S/N 550-0704 N19HUStoneway Aviation LLC · Prospect, KYBuilt 1991 · S/N 560-0135 N19MCFlying B Holdings LLC · Ozona, TXBuilt 1988 · S/N FA-167 N19QCOn Three Angels Wings LLC · Melbourne, FLBuilt 1994 · S/N 650-0238 N1HXCentralav LLC · Lake Worth, FLBuilt 1978 · S/N BB-361 N1NLNeil F Lampson Inc · Kennewick, WABuilt 1998 · S/N 550-0857 N1PTWarner Aviation Properties LLC · Austin, TXBuilt 1987 · S/N FA131 N1SVJtl Leasing Co LLC · Kalispell, MTBuilt 1980 · S/N 550-0150 N1TYOwens Scotty · Crofton, KYBuilt 1980 · S/N 550-0171 N1UMUniversity Of Mississippi · University, MSBuilt 2000 · S/N 560-0543 N2000X4thd LLC · Midland, TXBuilt 1994 · S/N 560-0249 N200ASRha Air LLC · North Little Rock, ARBuilt 2000 · S/N 550-0934 N200BTMid-South Regional Aviation LLC · Tunica, MSBuilt 1977 · S/N BB-293 N200GWNogottie Landing Co LLC · Amarillo, TXBuilt 1979 · S/N BB-568 N200JLCrest Trading Company · Bakersfield, CABuilt 1975 · S/N BB-40 N200LHEagle Nation Aviation LLC · Macon, GABuilt 1992 · S/N 650-7005 N200NCMidwest Jet LLC · Lynd, MNBuilt 1980 · S/N 550-0184 N200NSContinental Land Co LLC · Wilmington, DEBuilt 2000 · S/N 550-0949 N200PZBeech Transportation Inc · Eden Prairie, MNBuilt 1978 · S/N BB-410 N200VAVargus Group Inc · Providence, RIBuilt 1977 · S/N BB-246 N200WXMorales J Mark Trustee · Corpus Christi, TXBuilt 1979 · S/N BB-680 N201SUImp Inc · Coatesville, PANon-citizen corporation, flight hours not reportedBuilt 2001 · S/N 560-0586 N202AVAvista Corp · Spokane, WABuilt 1999 · S/N 650-7108 N202JKRosado Aviation Inc · Moosic, PABuilt 1985 · S/N 650-0100 N202JPAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1994 · S/N 650-7046 N202PPTwin P Aviation LLC · Fort Worth, TXBuilt 2007 · S/N 560-0753 N203HSPbi Aviation LLC · Dallas, TXBuilt 1992 · S/N 5600203 N203TASouthwest Aviation Specialties LLC · Tulsa, OKS/N BB-658 N204BBCentex Aero LLC Trustee · San Antonio, TXBuilt 1990 · S/N 650-0189 N204BGPrecision Aviation Inc · Kimberly, IDBuilt 1999 · S/N 560-0503 N204CFCorporate Flight Inc · Waterford, MIBuilt 1980 · S/N 550-0238 N204PMDodson International Parts Inc · Rantoul, KSBuilt 1981 · S/N 550-0320 N204TPW & W Innovative Enterprises LLC · Douglas, GABuilt 1976 · S/N BB-115 N2057HCam Jet Aviation LLC · Lamesa, TXBuilt 1981 · S/N 550-0274 N206PRidgeaire Inc · Jacksonville, TXBuilt 1979 · S/N BB-466 N208AVTeton Leasing LLC · Pocatello, IDBuilt 1996 · S/N 560-0358 N208BCOutside In Aviation LLC · Fort Madison, IABuilt 1975 · S/N BB89 N208FDelaware Baron Leasing Partners LLC · Wilmington, DEBuilt 1981 · S/N BB-851 N208VPN771at LLC · Lewes, DES/N 560-0208 N209CV209cv LLC · Bozeman, MTBuilt 1993 · S/N 560-0209 N20AEButler Aviation Inc · Houma, LABuilt 1981 · S/N BB827 N20CCGunnslinger Air LLC · Destin, FLBuilt 1998 · S/N 560-0467 N20RADepartment Of The Air Force · Hill Afb, UTBuilt 1985 · S/N UB-42 N20YTWoodbine Aviation LLC · Lewes, DES/N 550-0213

Back to AD 90-06-13