OpenAirDocs.org
AD 2007-18-08

Registered aircraft · 59

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

N100CUJani King Aviation LLC · Addison, TXBuilt 1977 · S/N 104N100FJAvw Equipment Co Inc · Maywood, ILS/N 118N100KUNion LLC · New Century, KSBuilt 1981 · S/N 183N100YPJk LLC · Ridgeville, SCBuilt 1988 · S/N 222N108KCV1vr LLC · Wilmington, DEBuilt 1974 · S/N 8N10FKing Leasing Corp · San Diego, CABuilt 1974 · S/N 12N10NCHayward Enterprises Inc · High Point, NCBuilt 1980 · S/N 172N111WHWhiskey Hotel LLC · Houma, LAS/N 167N147GXAltair Aviation LLC · Missoula, MTBuilt 1987 · S/N 214N150SSSweetener Supply Corp · Brookfield, ILBuilt 1987 · S/N 213N174BFlying Farmer LLC · Wilmington, DEBuilt 1979 · S/N 142N175CJFlying Farmer LLC · Wilmington, DEBuilt 1980 · S/N 175N17AQDalila Aero Inc · Wilmington, DENon-citizen corporation, flight hours not reportedS/N 120N197MJSkyview LLC · Wilmington, DES/N 197N1989BN455jw LLC · Missoula, MTBuilt 1988 · S/N 217N1JWRed River Aircraft Leasing LLC · Anchorage, AKBuilt 1982 · S/N 200N204WSPremier Aircraft LLC · East Alton, ILBuilt 1981 · S/N 181N211ECEast Coast Flight Services Inc · Easton, MDBuilt 1980 · S/N 166N212FJDodson International Parts Inc · Rantoul, KSBuilt 1979 · S/N 147N220CVDodson International Parts Inc · Rantoul, KSBuilt 1988 · S/N 220N222MULanier Air East Coast LLC · Pineville, NCBuilt 1980 · S/N 164N244AFlying Farmer LLC · Wilmington, DEBuilt 1979 · S/N 145N256VGitsis Nick Trustee · MakatiBuilt 1979 · S/N 151N25STLewis Garry L · Livingston, LABuilt 1982 · S/N 198N272DNDel Mar College · Corpus Christi, TXBuilt 1978 · S/N 135N282TRed Star Aero Holdings LLC · Lewes, DEBuilt 1974 · S/N 42N30TEV1vr LLC · Wilmington, DEBuilt 1980 · S/N 152N316GBWellsprings Aviation LLC · Winston Salem, NCS/N 103N320GWSky Wheeels LLC · Prince Frederick, MDBuilt 1981 · S/N 180N333KEFalconmitch Inc · Sulphur Springs, TXBuilt 1974 · S/N 14N34TJAbove The Rest Aircraft Services LLC · Midlothian, TXBuilt 1975 · S/N 41N35CDCoastal Development Group LLC · Boca Grande, FLBuilt 1989 · S/N 224N362PTN378c LLC · Parker, COS/N 73N401JWWatts John I · Murchison, TXBuilt 1975 · S/N 46N42GEWatts John · Murchison, TXBuilt 1974 · S/N 20N454DPSkyview LLC · Wilmington, DES/N 130N463AKFlying Farmer LLC · Wilmington, DEBuilt 1980 · S/N 162N46MKSplendid Jet Lease LLC · Cape Coral, FLS/N 206N54DRGarcia David D · Midlothian, TXS/N 94N5CAMach 87 LLC · Sulphur Springs, TXBuilt 1981 · S/N 187N606AMSl Jet LLC · Cleveland, TNS/N 205N653FJDwts LLC · Powder Springs, GAS/N 110N655PEDunbar Aviation LLC · West Kingston, RIBuilt 1982 · S/N 199N6FJFlying Farmer LLC · Wilmington, DEBuilt 1977 · S/N 97N707CXV1vr LLC · Wilmington, DEBuilt 1988 · S/N 216N715JCFlying Farmer LLC · Wilmington, DEBuilt 1977 · S/N 99N717DHDarkhorse Aviation LLC · Georgetown, TXBuilt 1990 · S/N 226N71MSkyview LLC · Wilmington, DEBuilt 1976 · S/N 88N725CJClub Jet Investments LLC · Wilmington, DEBuilt 1974 · S/N 25N73LRFalcon N73lr LLC · Belton, TXBuilt 1974 · S/N 35
Back to AD 2007-18-08