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.

N3028HRegistered aircraftBuilt 1978 · S/N 28-7911054N3028MLittle Robert · Ocala, FLBuilt 1978 · S/N 28-7816397N3028QAllenspach Timothy L · Stillwater, MNBuilt 1967 · S/N 18258028N3028WK2 Aviation LLC · Carroll, IABuilt 1973 · S/N E-465N3028YStanton Tod J · Naperville, ILBuilt 1962 · S/N 18254028N3028ZDavis Robert L · Wasilla, AKS/N 22-6982N30293Advantage Aviation Services LLC · South Saint Paul, MNBuilt 1968 · S/N 17701177N30297Siers Richard · Ocean Shores, WABuilt 1968 · S/N 17701178N3029CHeyneman John M · Sheridan, WYS/N D-5694N3029HSmith Zachary · Nokesville, VABuilt 1978 · S/N 28-7911055N3029MBaumgartner Rhone J · Mc Grath, AKS/N 12-1720N3029QOzarks Auto Show Inc · Hollister, MOBuilt 1967 · S/N 18258029N3029ZSuper 20 LLC · Brandon, SDBuilt 1959 · S/N 22-6983N302AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281190N302AMHughes Jason · Visalia, CABuilt 1965 · S/N 618N302AVRas Aviation LLC · Elyria, OHS/N 28-7716283N302BCG2 Leasing LLC · Cedar Spring, MIBuilt 1982 · S/N E-1982N302BYAviation Homes LLC · Terrell, TXBuilt 2004 · S/N 0985N302CDChadmatt Explorations LLC · Pensacola, FLBuilt 2004 · S/N 1076N302CFEastern Kentucky University · Richmond, KYBuilt 2002 · S/N 17281137N302CMMurray Craig W · Raymond, WABuilt 2002 · S/N 5742N302CWWarrington James Whittaker O Jr · Lexington Park, MDBuilt 1976 · S/N 7057CN302DBHouston Chet H · Beaufort, SCBuilt 1968 · S/N 17701132N302DSMt Zephyr Enterprises LLC · Yorktown, VABuilt 2007 · S/N 40.742N302EFRedbird Ventures LLC · Kalispell, MTS/N 34-7350328N302FGTactical Aviation LLC · Plymouth, MIBuilt 1980 · S/N 28-8016274N302GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881458N302GPInternational Air Services Inc Trustee · Carson City, NVS/N 21058682N302JAAviate LLC · Green Bay, WIBuilt 1977 · S/N 17269488N302JBS C Flying Service Inc · Ravenden Springs, ARBuilt 1998 · S/N 1417N302JHYang LLC · Lewisburg, WVBuilt 1962 · S/N CD-517N302KTSkydrift Aviation LLC · Kalispell, MTBuilt 1999 · S/N 3200N302MAHopler Harold W · Helena, MTBuilt 2002 · S/N 5158N302MCB & G Ventures LLC · Kalispell, MTBuilt 1973 · S/N 310Q0909N302MGGeorgia Aviation Authority · Eastman, GABuilt 2026 · S/N 28010002N302MPKqm Aviation · Bristow, VABuilt 2010 · S/N 18282273N302MXGove Gary Alan Jr · Marion, MTS/N 2008N302NLRussell Grant R · Roxbury, CTBuilt 1995 · S/N 062N302PASkywest Leasing Inc · St George, UTBuilt 2002 · S/N 4496121N302RMHillger Michael D · Garden City, TXBuilt 2015 · S/N 71594N302SKHaynes Daniel R · New Braunfels, TXBuilt 1965 · S/N 310J-0036N302STManagement Support Services LLC · Naturita, COBuilt 1968 · S/N T210-0350N302TXCareer Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13221N302USolomon Mark Trustee · Wilmington, DEBuilt 1964 · S/N 18255529N302WDivine John S III DBA · Myrtle Beach, SCS/N E-302N302ZSutherland Derrick L · Ada, OKBuilt 1960 · S/N CD-201N30301Brown Gregory R · Spotsylvania, VABuilt 1962 · S/N CD-450N30302Kamenar Service LLC · Mukwonago, WIBuilt 1968 · S/N 17701180N30304Williams Rod · Atascadero, CABuilt 1968 · S/N 17701182N30307Johnston Phillip Jr · Pensacola, FLBuilt 1968 · S/N 17701184
Back to AD 2007-04-19 R1