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.

N30877Pompano Senior Squadron Flying Club Inc · Pompano Beach, FLBuilt 1978 · S/N 28-7890457N3087CHarless Steven M · Brighton, COS/N 20031CN3087FCascio John T · Deland, FLBuilt 1966 · S/N 18257187N3087QCollins Allen Shane · Amarillo, TXBuilt 1967 · S/N 18258087N3087RCrest Aviation LLC · Palmer, AKS/N 28R-35646N3087TArroniz Valentin · San Juan, TXBuilt 1972 · S/N 28-7225542N3087UShelite Michael J · Enid, OKS/N 17250687N30881Garver John H · Fairland, INS/N 17701523N30887Needham Victor T Jr · Park Forest, ILBuilt 1970 · S/N 17701525N30888Propwash LLC · Frankenmuth, MIBuilt 1970 · S/N 17701526N30889Abbott Michael S · Radford, VABuilt 1970 · S/N 17701527N3088CMeester Daniel J · Longmont, COBuilt 1958 · S/N D-5773N3088DAquasol Corp · Rock Hill, SCBuilt 1987 · S/N E-2398N3088FDoepker James E · Kalispell, MTBuilt 1966 · S/N 18257188N3088GRox Air LLC · Montgomery, OHBuilt 1963 · S/N 30-88N3088LRice James M · Austin, TXS/N 310J0088N3088QRosenblatt Jeffrey A · Portland, MES/N 18258088N3088YCathey Michael · Chattanooga, TNBuilt 1962 · S/N 18254088N3088ZRavens Rebuilders Inc · Ellenboro, WVBuilt 1959 · S/N 18-7142N30892Salvagnini David R · Falls Church, VABuilt 1970 · S/N 17701529N30894Hartacres LLC · Kalispell, MTBuilt 1970 · S/N 17701531N3089CWeatherly Richard A · Newport, WABuilt 1958 · S/N D-5772N3089HWilliamsburg Air Service Inc · Kingstree, SCBuilt 1988 · S/N CE-1219N3089QBrotnov Jerald W · Clarkston, WABuilt 1967 · S/N 18258089N3089RFly Bms LLC · Elkton, SDBuilt 1969 · S/N 28R-35649N3089THalverson Wyatt · Colbert, WABuilt 1972 · S/N 28-7225545N3089YSymbiotic Assets LLC · Winnemucca, NVBuilt 1962 · S/N 18254089N3089ZSnyder Stephen F · Paradise Valley, AZBuilt 1987 · S/N E-2402N308BBCartwright James · Summerland Key, FLS/N TC-1886N308BCMike Kilo Foxtrot LLC · Wilmington, DEBuilt 1979 · S/N 21063618N308CDM&R Transport LLC · Dover, DEBuilt 2004 · S/N 1026N308CFBaba Kenneth D · Sierra Vista, AZBuilt 1973 · S/N 310Q0804N308CWHeritage Investment Corp · Arlington, TXBuilt 2004 · S/N S1869N308EShannon Jesse L · Boise City, OKS/N D-5763N308FAStratus Rr LLC · New Castle, DEBuilt 2023 · S/N 28020108N308FDN308fd LLC · Janesville, WIBuilt 1984 · S/N 8039CN308KFAb Prop Plane I LLC · Metairie, LABuilt 2024 · S/N 296/USN308MGGeorgia Aviation Authority · Eastman, GABuilt 2026 · S/N 28010011N308MTBadje Seth J · Hay Springs, NEBuilt 2020 · S/N 001N308NGR N Geraci LLC · Lutz, FLBuilt 2014 · S/N 3220N308NRState Of Wisconsin · Madison, WIBuilt 2024 · S/N 18283262N308PDmm Air Shows LLC · Wilmington, DEBuilt 1977 · S/N TC-2103N308RZone Five LLC · Saint Petersburg, FLBuilt 2008 · S/N 82385N308RLAulisio Anthony III · Dana Point, CAS/N 205-0110N308SALangley Richard · Sheyenne, NDBuilt 2021 · S/N 14502N308SLLeibbrandt Steven E · Imperial, NEBuilt 1968 · S/N 18259354N308SPAmeriflyers Of Texas Inc · Addison, TXBuilt 2003 · S/N 172S9487N308SUHagele Aviation LLC · Hillsboro, ORBuilt 1981 · S/N 17275027N308TATrinity Aviation LLC · Georgetown, TXBuilt 2001 · S/N 453-2000N308TSSimson Theodore A · Sherwood, ORBuilt 2018 · S/N TC0705015
Back to AD 2007-04-19 R1