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.

N544RLPlane Leasing LLC · Wilmington, DEBuilt 2004 · S/N 1384N544SABlack Ops Asphalt LLC · Kingsport, TNBuilt 2006 · S/N 11145N544SBHd Aviation Services LLC · Pembroke Pines, FLBuilt 2007 · S/N 1759N544SHAg Farmacy Applications LLC · Erie, ILBuilt 2005 · S/N 10818N544STGordon Jonathan · Bronxville, NYBuilt 1969 · S/N CJ-22N544SWCatherine Michaels Investment Services LLC · Carlsbad, CABuilt 2000 · S/N 2843388N544TAWright Richard L Jr · Flower Mound, TXBuilt 1973 · S/N 28-7305455N544TGKavalair LLC Series C · Marion, MTBuilt 2006 · S/N 11177N544VIngle Maurice O III · Claremore, OKBuilt 1965 · S/N D-7904N544VBElysium Fx Inc · Port Orange, FLBuilt 2015 · S/N 13811N544WBCharlie Foxtrot Airworks LLC · Jacksboro, TXBuilt 1997 · S/N 21544N544WMCampbell Greg L · Greenville, WIBuilt 2012 · S/N 3358N544ZLeary Ken R · Fairbanks, AKBuilt 1971 · S/N 18052190N545Providence Aerospace LLC · Choctaw, OKS/N 50001N54502Ho Simpson S · Poway, CABuilt 1981 · S/N 17274991N5450BKunz George M · Bakersfield, CABuilt 1956 · S/N 33450N5450DAirline Holding Co Inc · Wilmington, DEBuilt 1957 · S/N D-4978N5450EMiller Byron W · Silverton, ORS/N 2507N5450FN5450f LLC · Fernandina Beach, FLBuilt 1976 · S/N 28-7790126N5450HLima-001 LLC · Muscatine, IABuilt 1975 · S/N 17265446N5450LNorman Craig Gentry · Brenham, TXBuilt 1973 · S/N AA5-0350N5450PRegistration Pending · Sun Lakes, AZRegistration pendingBuilt 1958 · S/N 24-505N5450UStay Air Borne LLC · Wilmington, DEBuilt 1967 · S/N D-8529N5450WChambers Kirk · Delta, OHBuilt 1962 · S/N 28-528N5451DRestoration Ministry Inc · Allentown, PAS/N D-5252N5451KSkywarior Flight Training Inc · Pensacola, FLBuilt 1980 · S/N 17274117N5451LSymond Christopher M · Riverton, UTS/N AA5-0351N5451NMiller Geoffrey J · Tucson, AZBuilt 1980 · S/N 18267724N5451UHeijmans Michael L · Port Orange, FLBuilt 1967 · S/N CE-164N5451VParker James C · Cuthbert, GABuilt 1975 · S/N 21060952N5451WAndre Craig W · Pierre, SDBuilt 1962 · S/N 28-529N5452KAviation Club LLC · Sussex, NJBuilt 1980 · S/N 17274118N5452PLewis Nathan W · Vale, ORBuilt 1958 · S/N 24-508N5452UAlchemist Aviation LLC · Tallahassee, FLBuilt 1967 · S/N CD-1101N54531Jordan Alex N · Clarkton, NCBuilt 1981 · S/N 17274995N5453JC L Flight Associates LLC · Bakersfield, CAS/N 340A0111N5453KDodson International Parts Inc · Rantoul, KSBuilt 1980 · S/N 17274119N5453LTwo Tracts LLC · Sheridan, WYBuilt 1973 · S/N AA5-0353N5453PNoel Andrew F Jr · Morton, WABuilt 1958 · S/N 24-509N5453TSale Reported · WeidenSale reportedBuilt 1982 · S/N R18201870N5453WWheeler Dale · Valencia, CAS/N 28-531N5454DLelouis Michael P · Sacramento, CABuilt 1957 · S/N D-4942N5454KGolden Mahalo LLC · Sheridan, WYBuilt 1980 · S/N 17274120N5454LCarboneau Luke M · Las Cruces, NMBuilt 1973 · S/N AA5-0354N5454NLeisure Flight LLC · Franklin, TNBuilt 1980 · S/N 18267725N5454PRio Grande Flying Association Inc · Center, COBuilt 1958 · S/N 24-510N5454XKair Aviation · Parkland, FLS/N 340A1512N54550Chavez Clifford L · Seguin, TXBuilt 1978 · S/N JV5N5455EHaddix Christopher W · Chugiak, AKS/N 2512N5455HMiller Michael R · Portage, MIBuilt 1975 · S/N 17265449
Back to AD 2007-04-19 R1