OpenAirDocs.org
AD 2012-06-21

Registered aircraft · 129

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

N100AXApplied Underwriters Inc · Omaha, NEBuilt 1995 · S/N 155N100UPFj100 LLC · Waco, TXBuilt 1988 · S/N 44N101WFBl Custom Equipment LLC · Cincinnati, OHBuilt 2003 · S/N 197N105BKJetcom LLC · Lemon Grove, CABuilt 1989 · S/N 070N107GLLeep Enterprises LLC · Mishawaka, INBuilt 2002 · S/N 199N108FJBuffalo Valley Ventures Of Tn LLC · Cookeville, TNBuilt 1991 · S/N 108N108PHYoung Family Aviation LLC · Sugar Grove, ILBuilt 1990 · S/N 87N10XBmd Leasing LLC · Portland, ORBuilt 2001 · S/N 190N111FJJfm Air LLC · Wilton Manors, FLBuilt 1993 · S/N 128N116RWCerovest Capital LLC · Lawrenceville, GABuilt 1988 · S/N 058N1210NTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1991 · S/N 105N122AVase Corp V · Doral, FLBuilt 1990 · S/N 88N131LGCharter Express Inc · Little Rock, ARBuilt 1988 · S/N 055N137SHDream Global Parts LLC · Lawrence, KSS/N 137N140FJM Investments LLC · San Diego, CABuilt 1995 · S/N 140N14NAAnschutz Corp · Englewood, COBuilt 1992 · S/N 124N150KMCcn Aircraft Holdings LLC · Portland, MES/N 62N18MZRegistration Pending · Aledo, TXRegistration pendingBuilt 1987 · S/N 32N192RSR&S Aviation Inc · Rancho Cucamonga, CABuilt 1995 · S/N 143N202WRDumont Associates Inc · Morris Plains, NJBuilt 1987 · S/N 24N20GPN83 Charlie Inc · Fort Wayne, INBuilt 1992 · S/N 113N211WGPentair LLC · Palmetto, FLBuilt 2006 · S/N 142N21HMIheartmedia Management Services Inc · New York, NYBuilt 1988 · S/N 41N233KCMp Air LLC · Eagle Point, ORBuilt 1998 · S/N 48N239AXAviation8 LLC · Carle Place, NYBuilt 1987 · S/N 39N247FRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 184N25MXAce Parts LLC · Santa Fe Springs, CABuilt 1999 · S/N 182N271ACTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 189N288FATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1994 · S/N 148N28DCMbogo Energy LLC · Boerne, TXBuilt 1994 · S/N 139N306SHN306sh LLC · Chicago, ILBuilt 1995 · S/N 150N310ZAZair Force One LLC · Mendenhall, MSBuilt 1987 · S/N 009N314SJHrm Aviation LLC · Chesterfield, MOBuilt 1992 · S/N 115N328JLLamon Aviation LLC · Boise, IDBuilt 1996 · S/N 157N333DLD&S Aircraft LLC · Chicago, ILBuilt 1997 · S/N 163N345KMJdr Management LLC · Boca Raton, FLBuilt 1986 · S/N 3N361KBpcp Falcon N361k LLC · Wilmington, DES/N 83N38TVLs Mobile LLC · Weatherford, TXBuilt 1988 · S/N 37N411CDRegistered aircraftBuilt 1994 · S/N 138N450FVYellowdome LLC · Emigrant, MTBuilt 1992 · S/N 112N46HBSunshining Aviation LLC · Wilmington, DEBuilt 1988 · S/N 42N484FMV1vr LLC · Wilmington, DES/N 81N48KZN48kz LLC · Long Beach, CABuilt 2001 · S/N 191N4BAMonte Carlo Associates LLC · Santa Ana, CABuilt 2003 · S/N 200N504PASmee Homes Inc · Porterville, CABuilt 1988 · S/N 43N504STSdt Air Delaware LLC · Wilmington, DEBuilt 1996 · S/N 162N508MMMarklyn Jet Parts LLC · Dallas, TXS/N 66N516JAKings Aviation Corp · Garden City, NYBuilt 1991 · S/N 089N522TLDodson International Parts Inc · Rantoul, KSS/N 98N527SRedleaf Management Company LLC · Miami, FLS/N 8
Back to AD 2012-06-21