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.

N548JHHagg Jeffrey D · Indianapolis, INBuilt 2007 · S/N 54806N548MWMalone John Grover · Jasper, FLS/N 22475N548NDAerosim Academy Inc · Sanford, FLBuilt 2010 · S/N 172S11050N548PGuin Wilson L · Alamogordo, NMS/N 33480N548RGosnell Christopher Carter · Magnolia, ARBuilt 2005 · S/N 18281576N548SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881340N548SMMorrow James S · Gilbert, SCBuilt 2006 · S/N 001N548TFrasier Samuel R · Gainesville, FLBuilt 1961 · S/N TD-455N54904Quality Aviation Inc · Marana, AZS/N 25-7656033N54905905 Cess LLC · Wilmington, DEBuilt 1981 · S/N 17275076N54909Soaring Society Of Dayton Inc · Waynesville, OHBuilt 1976 · S/N 25-7656049N5490AN5490a LLC · Rutherfordton, NCBuilt 1979 · S/N 21063467N5490ERoberson Terry K · Tampa, FLBuilt 1983 · S/N 18268327N5490HSuperior Flying Services LLC · Superior, WIS/N 17265462N5490JCullen Clay T · Danbury, CTS/N 310R0288N5490WHobbs Alicia · Folsom, CABuilt 1962 · S/N 28-575N54910Somboonsap Patanapong · Oakland Park, FLBuilt 1981 · S/N 17275077N54914Csa Foundation Inc · Wellington, COBuilt 1976 · S/N 25-7656055N54915Mohawk Soaring Club Inc · Hoosick Falls, NYBuilt 1976 · S/N 25-7656056N5491BSmith Richard D II · Luthersville, GABuilt 1956 · S/N 33491N5491HSky Hogs LLC · Orange Park, FLBuilt 1975 · S/N 17265463N5491JChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 172S10395N5491KSale Reported · Rowland, NCSale reportedBuilt 1980 · S/N 17274156N5491NLacefield Tommie C · Niceville, FLBuilt 1980 · S/N 18267756N5491UAarestad Potato Co Ltd · Halstad, MNBuilt 1967 · S/N D-8584N5492DCekinovich Ted M · Machesney Park, ILBuilt 1956 · S/N D-5018N5492HAcme Aircraft Flying Club LLC · Kalispell, MTBuilt 1975 · S/N 17265464N5492PArbuckle Ian A · Montgomery, TXBuilt 1958 · S/N 24-553N5492ULawrence Christopher L · Panama City, FLBuilt 1967 · S/N CD-1116N5492WSky Park Cherokees Inc · Felton, CABuilt 1962 · S/N 28-577N54933Sammy Supercub LLC Series B · Reno, NVS/N 18-7709022N54938Lentsch Bill · Fairbanks, AKBuilt 1977 · S/N 18-7709024N54939Lang Madison S · Harper, TXBuilt 1976 · S/N 18-7709025N5493DAcres Aviation LLC · Fremont, NEBuilt 1957 · S/N D-5022N5493NOcaid Equipment Leasing LLC · Spring Valley, NYBuilt 1980 · S/N 18267757N5493PGear Up Aviation LLC · Santa Clara, CAS/N 24-554N5493RFreedom Flight Center Inc · Hardy, NEBuilt 1979 · S/N 172RG0064N54946Goosfraba LLC · Huddleston, VABuilt 1981 · S/N 17275084N54947Christiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 17275085N5494DGulp LLC · Ardmore, OKBuilt 1957 · S/N D-5026N5494EBloom William K · Wrangell, AKBuilt 1979 · S/N 18503983N5494LZee Sutherland L · Stallings, NCBuilt 1973 · S/N AA5-0394N5494TCampbell Barry E · Prescott, AZBuilt 1982 · S/N R18201879N5494UEdwards Michael L · Mesilla Park, NMBuilt 1967 · S/N CD-1109N54951Skylens LLC · Hammond, LABuilt 1981 · S/N 17275087N54955Space 5 LLC · Fayetteville, GABuilt 1982 · S/N 17275089N54956Fluke Dennis M · Sunset, TXBuilt 1981 · S/N 17275090N5495ARzs Enterprises Inc · Finley, NDBuilt 1979 · S/N 21063470N5495BCable Strong Aircraft Holdings LLC · Tyler, TXS/N 33495N5495DSorbi Aviation Inc · El Cajon, CABuilt 1979 · S/N 17272587
Back to AD 2007-04-19 R1