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.

N529LWNelson Harry H · Orting, WABuilt 2005 · S/N 089N529MCRhoads Eric S · Costa Mesa, CABuilt 1981 · S/N 17274639N529MKBlue Ryan LLC · Englewood, COBuilt 2005 · S/N 1590N529NDPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2009 · S/N 172S10981N529PHoffman Andrew · Martinsville, INBuilt 1961 · S/N D-6686N529PHSilveraire LLC · Forest Lake, MNBuilt 1955 · S/N 31324N529RBBusby Ralph H III Trustee · Newport, ORBuilt 1960 · S/N TD-417N529SARaptorsair LLC · Mchenry, ILBuilt 2001 · S/N E-3429N529SWFrick Kurtis W · Larned, KSBuilt 1973 · S/N 28-7305450N529TDJohnson Timothy Dean · Walton, KYBuilt 1972 · S/N 17260741N529TTCarter Casey C · Sanger, TXBuilt 1959 · S/N 52658N529VMCgm Aviation LLC · Gainesville, FLBuilt 1993 · S/N 14582N52AAWebster Patrick Edward · Elk Grove, CABuilt 1975 · S/N MB-760N52AHSomax LLC · Dudley, MOBuilt 2021 · S/N 3378N52AJMccarty Aaron T · Wasilla, AKBuilt 1977 · S/N R18200089N52ATPowell Michael R · Anchorage, AKBuilt 1977 · S/N 1003N52AUUllman Aaron L · Barksdale Afb, LABuilt 1967 · S/N D-8484N52BRed Baron LLC · Middletown, DEBuilt 1988 · S/N 8-0084N52BCCottle Kevin Patrick · Daniels, WVBuilt 2008 · S/N 011N52BGJax Transport LLC · Amarillo, TXBuilt 2015 · S/N 13772N52CAAllison Charles L · Park Rapids, MNBuilt 1993 · S/N 1335N52CLDannebrog Air LLC · Grand Island, NEBuilt 1971 · S/N 28R-7135042N52CRCairns Douglas S · Bozeman, MTBuilt 1968 · S/N 18259237N52CSBombs Away LLC · Elkins, ARBuilt 1974 · S/N 414-0615N52DAHusky Aero LLC · Grand Forks, NDS/N 2033N52DKPierson Janice Trustee · Scio, ORBuilt 1975 · S/N DE892N52DMPetersen Stephanie Ann Trustee · Coronado, CABuilt 1963 · S/N E3B-624-2224N52DRJbpm LLC · Otisfield, MEBuilt 1973 · S/N 15075506N52DSGiaretta David · Arlington, TXBuilt 2009 · S/N 1107N52ENRefuge Properties LLC · Goshen, KYS/N 18263612N52ERFly Safe Southwest LLC · Vail, AZBuilt 1979 · S/N AA5B1095N52EVPacific Fleet Aviation LLC · Rochester, NYBuilt 1979 · S/N 27-8054006N52FCAccent 300 LLC · Opa Locka, FLBuilt 2003 · S/N 170N52FKSixgun Aviation LLC · Eddyville, KYBuilt 1991 · S/N 1122N52FSGreseth Harold · Buffalo, MNBuilt 1972 · S/N 426-73N52GBBurkett Gary L Trustee · Murfreesboro, TNBuilt 1977 · S/N 0761N52GKLanthrum Joseph G · Port Hadlock, WABuilt 2002 · S/N 28015CN52GMSchneider Jeffrey A · Pensacola, FLBuilt 1973 · S/N 70-73N52GSLqp Aviation LLC · Gary, SDBuilt 1968 · S/N E-122N52GVCompass Aviation Maintenance LLC · Shelby, NCBuilt 1978 · S/N R18200393N52HAAssociated Packaging Inc · Gallatin, TNS/N 18282226N52HCOak Bay Aviation LLC · Bellvue, WABuilt 1980 · S/N TJ-274N52HEMiller Harold L · Cressona, PABuilt 2012 · S/N 83016N52HMMead Charles Reese · Lake Havasu, AZS/N HM045N52HWBurns Robert B · Placerville, CABuilt 1966 · S/N 28-3466N52HYNorstegaard Brian M · Gillette, WYBuilt 2003 · S/N 2220N52JGMalloy Marc · Fletcher, NCS/N 670N52JHMonroe Scott E · Antelope, CABuilt 1981 · S/N 1N52JLFastair Enterprises LLC · Virginia Beach, VAS/N CD-1180N52JMJetstar Aviation Group LLC · Norlina, NCBuilt 1980 · S/N TC-2309
Back to AD 2007-04-19 R1