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.

N301FSNadh Development LLC · Santa Rosa, CABuilt 2022 · S/N 1565N301GASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N 18052490N301HLnc4 Mcx1 LLC · Rexburg, IDBuilt 1999 · S/N 137N301HEN301he LLC · Rehoboth Beach, DEBuilt 1993 · S/N 2382MN301JCGardner Jeffrey · Reno, NVBuilt 1980 · S/N 18267770N301JFGrace Eric C · Valdosta, GABuilt 1979 · S/N E-1593N301JKKaminski John J · Torrance, CABuilt 1978 · S/N 24-0634N301JRTropitech Inc · San Juan, PRBuilt 1973 · S/N 17261555N301JSOlson Nicholas D · Ankeny, IABuilt 1993 · S/N JS001N301KARivard Robert M · Grand Haven, MIBuilt 1981 · S/N 32R8113020N301KCRidl Kent S · West Fargo, NDBuilt 1978 · S/N 24-0414N301KG217 Aviation LLC · Winchester, ILBuilt 1988 · S/N 3213017N301KKBurris Timothy J · Fountain Inn, SCBuilt 1979 · S/N 32-7940092N301MCCharles Michael Maya · Erie, COBuilt 1978 · S/N 18503705N301MXRockin T Construction Inc · Swan Valley, IDBuilt 1998 · S/N 1391N301NDPutzke Becky A · Fort Ripley, MNS/N 17261763N301NLHammerhead Holdings LLC · Manassas, VABuilt 1998 · S/N 067N301PRussell Bill W · Victoria, TXBuilt 1978 · S/N TH-890N301PLCutbirth David B · Monahans, TXBuilt 1966 · S/N P206-0334N301PS3b1g Enterprises LLC · Phoenix, AZBuilt 1982 · S/N 32-8306007N301RS2f Trade LLC · Collinsville, TXS/N 21062473N301RVK6 Construction Inc · Clovis, CABuilt 2004 · S/N 1172N301RWRegistered aircraftBuilt 2008 · S/N 4264N301SHSpitzer Helicopter LLC · Wilmington, DEBuilt 2021 · S/N 4842N301SMCameron Ottis W · Comfort, TXFirst renewal noticeBuilt 1964 · S/N 534N301STTechnical Education Services Inc · Virginia Beach, VAS/N 28-25655N301TXSpitfire Aviation Inc · Wilmington, DEBuilt 1995 · S/N 1712N301WHWedekemper Steven E · Brighton, MIBuilt 2002 · S/N 150N3020CBrosnan Daniel · Mary Esther, FLBuilt 1958 · S/N D-5685N3020DAllen Gregory L · Lake View, ALFirst renewal noticeBuilt 1955 · S/N 35220N3020MWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 1979 · S/N 44-7995220N3020SAndre Frazier LLC · Anacortes, WABuilt 1979 · S/N 28-7916295N3020TRegional Helicopters LLC · Anchorage, AKBuilt 2007 · S/N 11778N3020WDague John · Monroe, INS/N 28R-7918087N3020YJ & T Sullivan Farms Gp · Macon, TNBuilt 1962 · S/N 18254020N3020ZCapece Richard N · Leonardtown, MDS/N 22-6972N30218Mckillip Kirby G · Kemah, TXBuilt 1968 · S/N 17701127N3021CUnited States Air Force Owner · Hanscom Afb, MABuilt 1978 · S/N 28-7916137N3021EAircraft Solutions LLC · Spokane, WABuilt 1978 · S/N 17271405N3021FRegistered aircraftBuilt 1966 · S/N 18257121N3021HWilcox Kenneth P · Peachtree City, GABuilt 1978 · S/N 28-7990200N3021KKj Cessna LLC · Waxahachie, TXS/N 28R-7918020N3021QPicco Anthony · Sykesville, MDBuilt 1967 · S/N 18258021N3021WElliott Robert · Hartington, NES/N E-459N3021ZRichard Harold L Jr · Greencastle, PABuilt 1959 · S/N 22-6974N30222Nass Aviation Inc · Selbyville, DEBuilt 1978 · S/N 28-7990086N30225Hall Curtis B · Shepherdsville, KYBuilt 1968 · S/N 17701131N3022EBoulais Aaron · Upland, CABuilt 1982 · S/N 18268227N3022MEllis Darry Lynn · Wasilla, AKBuilt 1946 · S/N 12-1722N3022NWinter Duncan F · Saranac Lake, NYBuilt 1979 · S/N 32R-7985074
Back to AD 2007-04-19 R1