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.

N346EXWebair LLC · Warrenton, VAS/N 346N34TJAbove The Rest Aircraft Services LLC · Midlothian, TXBuilt 1975 · S/N 41N35CDCoastal Development Group LLC · Boca Grande, FLBuilt 1989 · S/N 224N361KBpcp Falcon N361k LLC · Wilmington, DES/N 83N362PTN378c LLC · Parker, COS/N 73N373RRM10 LLC · Rolling Meadows, ILBuilt 1997 · S/N 259N37WXCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2000 · S/N 309N380CJSkyview LLC · Wilmington, DES/N 380N383ECAeronave Corp · Kalispell, MTBuilt 2007 · S/N C-177N383MCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 322N385RSAeronave Corp · Kalispell, MTBuilt 1991 · S/N C-042N388BBPw Transport LLC · Lafayette, LABuilt 1999 · S/N 281N38TVLs Mobile LLC · Weatherford, TXBuilt 1988 · S/N 37N395HEBillron LLC · Houston, TXBuilt 1992 · S/N 228N396JR396jr LLC · Macon, GABuilt 2005 · S/N 341N401JWWatts John I · Murchison, TXBuilt 1975 · S/N 46N404HRBudget Jet LLC · Delray Beach, FLBuilt 1985 · S/N 455N408CJDt Management Group LLC · Phoenix, AZBuilt 2000 · S/N 293N411CDRegistered aircraftBuilt 1994 · S/N 138N413VLFalcon Vl LLC · Wilmington, DEBuilt 2006 · S/N 345N42GEWatts John · Murchison, TXBuilt 1974 · S/N 20N438SJKalitta Charters LLC · Ypsilanti, MIBuilt 1981 · S/N 438N450FVYellowdome LLC · Emigrant, MTBuilt 1992 · S/N 112N454DPSkyview LLC · Wilmington, DES/N 130N463AKFlying Farmer LLC · Wilmington, DEBuilt 1980 · S/N 162N46HBSunshining Aviation LLC · Wilmington, DEBuilt 1988 · S/N 42N46MKSplendid Jet Lease LLC · Cape Coral, FLS/N 206N484FMV1vr LLC · Wilmington, DES/N 81N48KZN48kz LLC · Long Beach, CABuilt 2001 · S/N 191N4BAMonte Carlo Associates LLC · Santa Ana, CABuilt 2003 · S/N 200N500CFPool Plane LLC · Seattle, WABuilt 2000 · S/N 303N500LY1380 Jets LLC · Pittsfield, MABuilt 2002 · S/N 323N504PASmee Homes Inc · Porterville, CABuilt 1988 · S/N 43N504STSdt Air Delaware LLC · Wilmington, DEBuilt 1996 · S/N 162N508MMMarklyn Jet Parts LLC · Dallas, TXS/N 66N50BLBnb LLC · Wilmington, DES/N 2N50FGRegenerative Sports Tissue Bank Inc · Lawrenceville, GABuilt 1988 · S/N 187N50PCSpritle LLC · Chicago, ILBuilt 2000 · S/N 308N50SNFirst Quality Falcon LLC · Great Neck, NYBuilt 2000 · S/N 310N50YPVillages Equipment Co · Leesburg, FLBuilt 2005 · S/N 344N50YTInternational Aviation Technical Services Inc · Torrance, CABuilt 1996 · S/N 269N510MPPark Avenue Aircraft Trust LLC Trustee · Dover, DEBuilt 1984 · S/N 140N511FLIfl Group Inc · Waterford, MIBuilt 1967 · S/N 122N5123Tpi Aircraft Interiors LLC · New Bern, NCBuilt 1984 · S/N 123N513SKHappy Skies LLC · Dover, DEBuilt 2004 · S/N 338N516CJTotal Aviation Corp · Garden City, NYBuilt 1980 · S/N 016N516JAKings Aviation Corp · Garden City, NYBuilt 1991 · S/N 089N520AWGg Flight LLC · Findlay, OHBuilt 1981 · S/N 453N522EECenergistic LLC · Dallas, TXBuilt 1999 · S/N 282N522TLDodson International Parts Inc · Rantoul, KSS/N 98
Back to AD 90-07-08 R1