OpenAirDocs.org
AD 2007-09-08

Registered aircraft · 35

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-09-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-09-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.

N14XTMccole Kevin · Brookline, NHBuilt 1986 · S/N 361N170WLIdpa Aircraft Leasing LLC · Austin, TXBuilt 2012 · S/N 468/CN17ZXIdpa Aircraft Leasing LLC · Austin, TXBuilt 2007 · S/N 433-29/OB2N19WLSouth Carolina Department Of Natural Resources · Columbia, SCBuilt 2004 · S/N 425-25/OB2N291CJArndt Scott · Pearland, TXBuilt 1983 · S/N 291N300LFAspen Helicopters Inc · Oxnard, CAS/N 295N340PNAspen Helicopters Inc · Oxnard, CABuilt 1985 · S/N 340-02/OTCN384VPAspen Helicopters Inc · Oxnard, CAS/N 384-01-OB2N3927UFresh Air Aviation Inc · Charlevoix, MIBuilt 1983 · S/N 282N419FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLBuilt 2002 · S/N 419-19/0B2N420KWCleghorn Aviation Inc · Key West, FLBuilt 1983 · S/N 294N468CBorn John · Jupiter, FLBuilt 1980 · S/N 213N480NROhio Division Of Wildlife · Columbus, OHBuilt 1986 · S/N 345N483FWNeel Aviation LLC · Lakeland, FLBuilt 1983 · S/N 271N490NROhio Department Of Natural Resources · Columbus, OHBuilt 1982 · S/N 281N4958KPilot Corp Of The Palm Beaches DBA · West Palm Beach, FLBuilt 1983 · S/N 269N564BCBravo Charlie Aviation Inc · Middletown, DENon-citizen corporation, flight hours not reportedBuilt 1984 · S/N 299N6307MN6307m LLC · Terra Ceia, FLBuilt 1985 · S/N 306N683KWOwyhee Air Research LLC · New Braunfels, TXBuilt 1983 · S/N 305N684KWFour Kilo Whiskey LLC · Key West, FLBuilt 1991 · S/N 387N686KWSix Kilo Whiskey LLC · Key West, FLS/N 364N68PVAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 442-07/OTCN68VAAspen Helicopters Inc · Oxnard, CABuilt 2007 · S/N 440/CN68VRGene Coleman Machine Inc · Menominee, MIBuilt 2004 · S/N 434N69HANorth County Flying LLC · North Palm Beach, FLBuilt 1990 · S/N 373N701United States Department Of Interior · Boise, IDBuilt 1990 · S/N 390-03-0B2N73N73n Aviation LLC · North Miami Beach, FLS/N 230N742WGTop View Corp · Livingston, MTBuilt 2023 · S/N 522/CN75NLFresh Air Aviation Inc · Charlevoix, MIS/N 312N76TWTennessee Wildlife Resources Agency · Nashville, TNBuilt 1991 · S/N 393-04-0B2N821BABarr Air Patrol LLC · Mesquite, TXBuilt 2007 · S/N 441-32/OB2N881BABarr Air Patrol LLC · Mesquite, TXBuilt 1983 · S/N 274N88NAspen Helicopters Inc · Oxnard, CAS/N 352-37/TCN90UBS-T Manufacturing Inc · Granbury, TXBuilt 1984 · S/N 302N91GFNew Mexico Dept Of Game And Fish · Santa Fe, NMBuilt 2009 · S/N 454-10/OTC
Back to AD 2007-09-08