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.

N39PVLeaving On Tulsa Time LLC · Tulsa, OKBuilt 2012 · S/N E-3985N39RFHughes Todd R · Euless, TXBuilt 1996 · S/N 532N39RHOlympic View Aircraft LLC · University Place, WABuilt 1977 · S/N TE-1113N39RLAdams Nathan M · Edgewater, FLBuilt 1972 · S/N 416-HN39SDMbm Leasing LLC · Jacksonville, NCBuilt 1966 · S/N 28-3565N39SJArrigo Johnathan T · Mill Spring, NCBuilt 1999 · S/N 3269N39SKJustman Robert A · Cotati, CABuilt 2003 · S/N 25726N39TBAlibi Flying Club · Bakersfield, CAS/N 3142N39TCPutnam Larry Paul · Tucson, AZBuilt 1979 · S/N E-1486N39TFFountain Timothy E · Miami Beach, FLBuilt 1976 · S/N CE-636N39TKCold Water Aviation LLC · Wabasso, MNBuilt 1983 · S/N EA-394N39TPAnderson Robert K · Cleveland, TNBuilt 1969 · S/N TE-780N39TSMiller William L · Williamson, GABuilt 1982 · S/N 39N39WBDorstewitz Robert D · Watervliet, MIS/N 1N39WDWilliams Ryan P · Calera, OKBuilt 1984 · S/N 106DN39WYGd Logistics LLC · Circle, MTBuilt 2011 · S/N 3119N39XPMason Samuel · Santa Paula, CABuilt 1976 · S/N K-039N39YBWeaver Brian R · Crossville, TNBuilt 2007 · S/N 91394N3AAJones Stephen C · Wadsworth, ILS/N E3B-318N3ACMaurer Christian N · Loveland, OHS/N 1002N3AGManaged Aviation Inc · The Villages, FLBuilt 1983 · S/N 60-8365018N3AKSantana Barry W · Wasilla, AKBuilt 2011 · S/N TC0604104N3AMBeavers William W · Bear Creek, NCFirst renewal noticeBuilt 1966 · S/N 1013N3AQSinnott-Simonis Lyle · Girdwood, AKBuilt 1955 · S/N 31744N3ARMatejczyk Daniel E · West Hills, CAFirst renewal noticeBuilt 1974 · S/N 10N3BCBenedict Larry · Dexter, NMBuilt 1956 · S/N 33947N3BDCopley Johnnie H · Minooka, ILBuilt 1979 · S/N 18267206N3BGHildreth James D · Kennedy, ALBuilt 1967 · S/N D-8612N3BNHansen Warren K · Bozeman, MTBuilt 1972 · S/N 430-73N3BRSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1973 · S/N D-9447N3BW4rc LLC · Kenedy, TXBuilt 1976 · S/N D-9870N3BYJamora Daniel L · Victorville, CABuilt 1969 · S/N 17257965N3CLWehner Kaitlyn M · Malone, WIBuilt 1968 · S/N 17257531N3CNCheck Six LLC · Champaign, ILBuilt 1981 · S/N BG-198N3CSStone Clifford F Jr · Corning, CABuilt 1972 · S/N CFS711N3CYSchultz Daniel A · Tipp City, OHBuilt 1972 · S/N P3370022N3DCPurpose Flight Inc · Wilmington, DES/N 1N3DMRogueaero LLC · Post Falls, IDBuilt 2024 · S/N 3138N3DNNodorft Daniel F · Orlando, FLBuilt 1983 · S/N 28-8390043N3DQCrescent Aviation LLC · Rllng Hls Est, CAFirst renewal noticeBuilt 1970 · S/N 414-0056N3DTBighorn Flying Company LLC · Wood River, NEBuilt 1962 · S/N 18-7774N3DWWhite Robert D Trustee · Colorado Springs, COBuilt 1973 · S/N 18262003N3DXMchugh Michael J Trustee · Hailey, IDBuilt 1973 · S/N D-9531N3DYRegistered aircraftBuilt 1981 · S/N YEAGLEY-0001N3DZXtreme Flying Club LLC · Gansevoort, NYS/N 33534N3EAEarle Aircraft Inc · Hastings, FLS/N CD-1193N3ECLindsey John T · Blue Earth, MNS/N 484RN3EHHoppe Nicholas J · Big Lake, AKBuilt 1961 · S/N 18051020N3ELTwo If Buy LLC · Nashua, NHBuilt 1978 · S/N 340A0525N3EM3em LLC · Karnack, TXBuilt 1981 · S/N P21000722
Back to AD 2007-04-19 R1