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.

N50ESSkinner Everett W IV · Stafford Springs, CTBuilt 2024 · S/N 14691N50EXBob Hoover Academy · Salinas, CABuilt 1994 · S/N 050N50FABeck Frank · Arvada, COBuilt 1972 · S/N AA5-154N50GBOviedo Juan M III · Oak Point, TXBuilt 1975 · S/N 340-0163N50GDTranguch John M · Beaver Meadows, PABuilt 1966 · S/N MA-128N50GTThomas Richard E · Lafayette, TNBuilt 1964 · S/N 310I0095N50GWWomack Craig D · Carlsbad, CABuilt 1993 · S/N 20370N50HFParagon Airplane Leasing Co · Fort Myers, FLBuilt 2023 · S/N 28020135N50HGBethune David Scott · Stockton, CABuilt 1979 · S/N TJ-217N50HURovegno Paul C II · Burlington, NCBuilt 1996 · S/N 1320N50HWMills Charles K · Hernando, FLBuilt 1978 · S/N U20604558N50HYGrossman David G · Itta Bena, MSBuilt 2000 · S/N 2116N50JAAday B Joe · Las Cruces, NMBuilt 1979 · S/N 18-8009002N50JCJg Air LLC · Wilmington, DEBuilt 1976 · S/N 18264656N50JKPorter Judson · El Paso, TXBuilt 2001 · S/N 25405N50JMMinter Michael D Jr Trustee · Rock Port, MOBuilt 1978 · S/N D-10141N50JPPowell John R · Baton Rouge, LABuilt 2013 · S/N 24118N50JTRiba Scott S · Montrose, COBuilt 1960 · S/N 22-7287N50KFBlade Capital Inc · Fort Lauderdale, FLBuilt 2009 · S/N 2035N50KMSexton David · Forney, TXBuilt 1991 · S/N 283N50KRVortex Air LLC · Philpot, KYBuilt 2014 · S/N 2379N50KSShuman Kenneth R · Adrian, MIBuilt 2001 · S/N 20535N50KWDsw Aircraft Ltd LLC · Kalispell, MTBuilt 2023 · S/N 42579N50LEFoulk Justin W · Yeagertown, PABuilt 1999 · S/N LE001N50LHRegistration Pending · Pensacola, FLRegistration pendingBuilt 2004 · S/N 81170N50LPParker-Long LLC · Lexington, NCBuilt 2026 · S/N TH-2551N50LRHester Truck Sales Inc · Bladenboro, NCBuilt 1995 · S/N 749-95N50LWFlyer One LLC · Palm Harbor, FLBuilt 1970 · S/N TE-790N50MAGoodhue David H · Vancouver, WABuilt 1979 · S/N 414A0434N50MBCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1980 · S/N U20605577N50MDBeifia Bedia Rafael · Winchester, VABuilt 1984 · S/N PA604N50MHWolpin Stephen A · Santa Paula, CABuilt 1984 · S/N 1403N50MRWhite Gordon · Bulverde, TXBuilt 1993 · S/N 21720N50MXPallozzi Francesco · Chadds Ford, PABuilt 1986 · S/N 0038N50NKAdcock Frank J · Atlanta, TXS/N 11835N50PFMitchell Kenneth A · Uniontown, PABuilt 1984 · S/N 28-8416084N50PGDrawe Richard · Progreso, TXBuilt 1994 · S/N 109575N50PJPremier Jets Inc · Hillsboro, ORBuilt 1976 · S/N AA5B-0287N50PKGuinn Dennis R · Nevada, TXBuilt 1968 · S/N 17701311N50PVVose Robert · Rye, NHBuilt 2009 · S/N PV192N50PWHandi Corner Inc · Sandersville, GABuilt 1978 · S/N 32R-7885045N50PZHill Robert P · Naknek, AKBuilt 1959 · S/N 51796N50RSells James O · Peachtree City, GAS/N 34-87N50RAWilson Kirk · Glennallen, AKBuilt 1963 · S/N 18051215N50RCBuric Ivan Nmn · Panama City, FLBuilt 1974 · S/N 177-02087N50RFFecteau Robert · Taylorsville, NCBuilt 2020 · S/N 18283099N50RHPlane Fun Inc Tr Trustee · Snellville, GABuilt 1981 · S/N P21000738N50RJThomas Ken · Vancouver, WABuilt 2007 · S/N 1N50RSStone Raymond J · Felton, DEBuilt 1977 · S/N 24-0177N50SBCobb Susie O · Fayetteville, TNBuilt 1978 · S/N TC-2134
Back to AD 2007-04-19 R1