AD 2007-04-19 R1

Registered aircraft · 108,434

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.

N29EEEiland Eddie L · Dublin, TXBuilt 1994 · S/N 1162N29EHRotary Run LLC · Zoar, OHBuilt 2005 · S/N 3889N29ERCosta Air Service LLC · Painted Post, NYBuilt 1977 · S/N 17269532N29FAJetson Blue LLC · Palm Coast, FLBuilt 2010 · S/N 60543N29FCUsda Forest Service Fepp · Raleigh, NCBuilt 1968 · S/N U206-1191N29FJSkyjack Motorsports · Bettendorf, IABuilt 1987 · S/N 7-0513N29FLTorres Chris · Princeton, CABuilt 1968 · S/N 18258813N29GHSutton Jaye Michael · Kaycee, WYBuilt 1998 · S/N 21019CN29GLHometime Rv LLC · San Antonio, TXBuilt 2008 · S/N 517-2008N29HJTesmer Steven J · Marshall, WIBuilt 1990 · S/N 134N29HKKellogg John H · Skaneateles, NYBuilt 2000 · S/N 3316N29HLSchreiber Christopher · Foley, ALBuilt 1975 · S/N 17266262N29HPRusso Kevin J · North Branch, NJBuilt 1976 · S/N E-831N29HTTrede 2023 LLC · Aurora, ORBuilt 2024 · S/N 172S13215N29HUClimb LLC · Kalispell, MTS/N 1381N29JDNyquist Mark R · Moorhead, MNBuilt 1984 · S/N 7466CN29JFJkg LLC · Murfreesboro, TNBuilt 1968 · S/N 18259450N29JJGourley Jonathon L · Graham, WABuilt 1996 · S/N RS1N29JLGriffin Justin B · Andrews, NCBuilt 1974 · S/N 1-0024N29JRLulafay LLC · Lewes, DES/N MA-235N29JVPrado Mike · Sugar Land, TXBuilt 2012 · S/N 91340N29KK29kk LLC · Manchester, MIBuilt 2003 · S/N 40071N29KMDebonair Consulting Inc · Wilmington, DEBuilt 1955 · S/N 31579N29KYBlack Ops Aviation LLC · Moorhead, IABuilt 2007 · S/N 1778N29LCareer Flyers LLC · Crittenden, KYBuilt 1966 · S/N 28-22418N29LGCameron Mark · Alpine, WYFirst renewal noticeS/N 184783N29LLDenver Rock Island Railroad · Commerce City, COBuilt 1976 · S/N 61P-0333-096N29LPElbert John E · Rohnert Park, CABuilt 1991 · S/N QQ14N29MFChas N Clark Associates Ltd · Laurel, MSBuilt 2000 · S/N TH-1966N29MXPeterson Jim · Bedford, WYBuilt 1975 · S/N 17266309N29NAGula Jason · Scranton, PABuilt 1969 · S/N 28-26246N29NCBeasley Fred Scott · Tulsa, OKBuilt 1967 · S/N 28-4277N29NEYankee Helicopters LLC · Plainville, CTBuilt 1987 · S/N 0691MN29PCFisher Douglas C · Mountain View, CABuilt 1979 · S/N 18266929N29PDDonlan Paul V · Bellevue, WABuilt 1992 · S/N 1002N29PGGroves Morton Dan Patrick · Menlo Park, CABuilt 2003 · S/N 40.341N29PJCastle Farms Inc · Sunnyside, WABuilt 1996 · S/N S1727N29PKKillcommons Peter · Independence, ORBuilt 1991 · S/N S 56N29PMAlly Mohamed Yacoob · Fort Lauderdale, FLS/N U20605769N29RBAdvantage Aviation Services LLC · South Saint Paul, MNS/N TD-174N29RFCaldwell Rob · Danville, KYBuilt 1979 · S/N E-1445N29RGHappy Raptor Flying Club LLC · Fort Lupton, COBuilt 1991 · S/N 5229N29RKRhk Of Kansas Inc · Jefferson City, MOBuilt 1982 · S/N TC-2451N29RMRedstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 1975 · S/N 28R-7535269N29RPBridges Gary N · Vidor, TXBuilt 2001 · S/N DMO380N29RRKhg Aviation Holdings LLC · Columbus, OHBuilt 1982 · S/N TJ-414N29RVKilby Brian C · Newnan, GABuilt 1997 · S/N 22789N29RXHey Aerial Application Services LLC · Childersburg, ALS/N 3470N29SCBrown Sherrie C · Cushing, OKBuilt 1962 · S/N 24-3125N29SDRegistered aircraftBuilt 1968 · S/N 28R-30583
Back to AD 2007-04-19 R1