OpenAirDocs.org
AD 2007-04-19 R1

Registered aircraft · 108,428

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-04-19-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:2007-04-19-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.

N12BCCentral Ohio Flyers Assn · Columbus, OHBuilt 1973 · S/N 18261895N12BDChaos Aviation LLC · Warrenton, VAS/N G-116N12BEElliott Russell R · Wasilla, AKS/N 7082CN12BGFull Scale Aviation LLC · Mccordsville, INBuilt 1982 · S/N TC-2412N12BJValentour Lance F · Naperville, ILBuilt 1974 · S/N 17264570N12BRManning Richard F · Midway, GABuilt 1957 · S/N D-5391N12BUVan Liew Bradford · Johns Island, SCBuilt 1968 · S/N TE-595N12BVRoberts William O · Lexington, VAS/N 0241N12CGGreen Carlton · Carmel Valley, CABuilt 1996 · S/N 1320N12CHKetchum Christensen Sky Chasers LLC · Midwest City, OKBuilt 1966 · S/N 18257291N12CKAmoss Harold Lindsay III · Redmond, ORBuilt 1990 · S/N 5179N12CYYeagle Aviation Inc · Port Saint Lucie, FLBuilt 1971 · S/N 310Q0247N12DDSpencer William D · Martinsville, VAS/N 248N12DKTim Cross Aviation LLC · Tucson, AZBuilt 1967 · S/N TE-290N12DMIsland Airways LLC · Marion, WIBuilt 1976 · S/N 18502947N12DPKish Gary A · Montrose, MIBuilt 1975 · S/N 1212DN12DSBuckbee Robert E · College Station, TXBuilt 1984 · S/N 27N12DUWoodtick Summit Aviation LLC · Redmond, ORBuilt 1979 · S/N U20605202N12EEArizona Cloudbusters Inc · Mesa, AZS/N 18280038N12EMMcneill Matthew C · Phoenix, AZBuilt 1966 · S/N CE-91N12ERPropelling The Gospel Missions Inc · Standish, MEBuilt 1976 · S/N 28-7615099N12EVDaedalus LLC · Little Rock, ARBuilt 1985 · S/N 46-8508065N12FGEchols Mill Aviation LLC · Elberton, GABuilt 1998 · S/N E-3219N12FJClement Nicolas · Littleton, MABuilt 1973 · S/N 18261732N12FMDelaware State University · Dover, DEBuilt 1978 · S/N 28-7816439N12FPElliott James R · Denton, TXBuilt 1974 · S/N 238N12FSLawley Frederick E · Bozeman, MTBuilt 1966 · S/N 30-1226N12GANy Flying Tigers LLC · Ronkonkoma, NYBuilt 1977 · S/N AA5B0635N12GBOliver Jonathan F Sr · Waxahachie, TXBuilt 1975 · S/N D-9789N12GCNorman Ashton J · Zanesville, OHBuilt 2000 · S/N 2264N12GLHayden Debra J · Utica, KYBuilt 1995 · S/N JR-2N12GNNauta Gordon Wayne · Palmdale, CABuilt 1977 · S/N 112N12GRJones Richard B · Georgetown, TXBuilt 2001 · S/N 2152N12GZBoettcher Aerial Co Inc · Beloit, KSBuilt 1974 · S/N 18801619N12HDMorotti John · Polson, MTBuilt 2022 · S/N 3401N12HEOlafsen George F · Greeneville, TNBuilt 2007 · S/N 91367N12HFParagon Airplane Leasing Co · Fort Myers, FLBuilt 2023 · S/N 28020131N12HGNaylor John H · Conway, ARS/N 1N12HHWilliams Jeffrey · Florence, ALBuilt 1989 · S/N 1688N12HJWoods Timothy J · Demarest, NJBuilt 2013 · S/N E-3990N12HPState Of Ohio · Columbus, OHBuilt 2002 · S/N 18281158N12HRHarben Grover S III · Gainesville, GABuilt 1991 · S/N 1664N12HTRanieri Paul A · Palatine, ILBuilt 2012 · S/N 5044N12HUVintage Flyers LLC · The Villages, FLBuilt 1997 · S/N 1345N12HYRegistration Pending · Nephi, UTRegistration pendingBuilt 1999 · S/N 1448N12HZBaldauf Ryan L · Spencerville, OHBuilt 1976 · S/N 17266707N12JGVosworx Aviation LLC · Morrison, COBuilt 1979 · S/N P21000365N12JLGiber Kristofor D · Manvel, TXBuilt 1961 · S/N 27-404N12JXAc Holdings II Inc · Lewes, DEBuilt 1981 · S/N 025N12KBWings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 17261915
Back to AD 2007-04-19 R1