OpenAirDocs.org
AD 90-07-08 R1

Registered aircraft · 311

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
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-07-08-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:90-07-08-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.

N8LTAviation Enterprises Inc · Marietta, GABuilt 1980 · S/N 173N900BBNical Aviation LLC · Austin, TXBuilt 1999 · S/N 284N900BKRck Aviation LLC · Woodside, CABuilt 2000 · S/N 187N900DTega Air LLC · Bend, ORBuilt 1993 · S/N 131N900EEIrish Air II LLC · Cincinnati, OHS/N 80N900ERJdr 192 LLC · Woody Creek, COBuilt 2001 · S/N 192N900KUFalcon 900-91 LLC · Lewes, DEBuilt 1991 · S/N 91N900KWAlta Airlines Holdings LLC · Salt Lake City, UTS/N 53N900LCMid Central Leasing LLC · Waukegan, ILBuilt 2000 · S/N 186N900LPDoctair Inc · Mclean, VABuilt 1987 · S/N 20N900MKRacer X LLC · Chicago, ILBuilt 1988 · S/N 40N900MWGlobal Jet Partners LLC · Scottsdale, AZS/N 78N900SBBg Air LLC · Hobbs, NMBuilt 1991 · S/N 107N900SFFalcon 900 LLC · Mount Laurel, NJBuilt 1987 · S/N 16N900TEFalcon 900 LLC · Ocala, FLBuilt 1986 · S/N 12N900TNRegistered aircraftBuilt 1996 · S/N 158N900VCFalcon-121 LLC · Salem, ORBuilt 1992 · S/N 121N900VPJdr 194 LLC · Woody Creek, COBuilt 2002 · S/N 194N900YBBold Access LLC · Leawood, KSBuilt 1987 · S/N 18N900YYBbps Aviation LLC · Mckinney, TXBuilt 1991 · S/N 101N901KRAvatar Wings LLC · Dallas, TXBuilt 1994 · S/N 146N902ABAngel Brothers Enterprises Ltd · Baytown, TXBuilt 2000 · S/N 298N905FJTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 1986 · S/N 5N906RARyan Air Inc · Anchorage, AKS/N 340A-109N907RARyan Air Inc · Anchorage, AKBuilt 1987 · S/N 340A-111N908TFSkyview LLC · Wilmington, DES/N 102N909JMRegistered aircraftBuilt 2000 · S/N 304N90FJWorldwide Aircraft Services Inc DBA · Tampa, FLBuilt 1998 · S/N 75N90GPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1987 · S/N 29N90HCFalcon Aviation LLC · Jupiter, FLS/N 208N90THJ & J Capital Ventures LLC · Wilmington, DEBuilt 1999 · S/N 180N910NMTriangle Real Estate LLC · Saint Peters, MOS/N 95N910SCSunchasing LLC · Newark, DEBuilt 1994 · S/N 144N910TX900 Consulting LLC · Austin, TXBuilt 1998 · S/N 172N914SSMeregrass Inc · Dublin, TXBuilt 2001 · S/N 188N914TV1365 Swan Ridge Road LLC · New York, NYBuilt 1987 · S/N 14N915TPGlobe Resources Group LLC · Wichita, KSBuilt 1992 · S/N 122N916KPKp Aviation Management LLC · Mather, CABuilt 2000 · S/N 301N917BCFlyaway Inc · Fort Worth, TXS/N 193N917JFAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1999 · S/N 179N918MVGuardian Aviation Services LLC · Short Hills, NJBuilt 1996 · S/N 156N919WTAir Waukegan LLC · Waukegan, ILBuilt 2001 · S/N 313N91MSLabbe LLC · Huntington Valley, PABuilt 1987 · S/N 10N921TBBluemaxx Air LLC · Friendswood, TXS/N 85N927BRFur Management & Consulting LLC · Junction, TXBuilt 2002 · S/N 196N92CJSkyview LLC · Wilmington, DEBuilt 1982 · S/N 092N947DTTkr Aviation LLC · Ballwin, MOBuilt 1992 · S/N 117N950HIsland Aviation Inc · Houston, TXBuilt 2000 · S/N 307N950SFTsl 2 LLC · Jackson, WYBuilt 1988 · S/N 50N955VGTvpx Aircraft Solutions Trustee · North Salt Lake, UTBuilt 2002 · S/N 328
Back to AD 90-07-08 R1