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.

N506HSChordwise Aviation LLC · Sedro Woolley, WABuilt 2014 · S/N 13646N506JMAims Community College · Greeley, COBuilt 2018 · S/N 4496432N506KGLone Star Land & Cattle Co · Houston, TXBuilt 2022 · S/N 14517N506MRegistered aircraftBuilt 2007 · S/N 90137N506PCShettlesworth Ryan C · Bloomington, INBuilt 1992 · S/N 1465N506RBChristiansen Aviation LLC · Wilmington, DEBuilt 1997 · S/N 2843092N506RVMelillo Peter J · Huntington Station, NYBuilt 1997 · S/N 22717N506SPHenrie Aviation LLC · Fairfield, NJBuilt 2000 · S/N 172S8363N506XLyons Leasing LLC · Zionsville, INBuilt 2003 · S/N 3232002N506XCMark A Hall LLC · Sunman, INBuilt 2016 · S/N CC19-0004N506YZR&R Gray Equipment & Cattle LLC · Enid, OKS/N 21059139N5070GSky Fusion II LLC · Atlanta, GABuilt 1980 · S/N 640-80N5070JCrc Properties Inc · Coto Laurel, PRBuilt 2013 · S/N TH-2370N5070KSmith Alice B · Escondido, CAS/N G-65N5070LHayden Daniel · North Pole, AKBuilt 1978 · S/N 18-7809122N5070NWilkinson Dane W · Morgan, UTBuilt 1980 · S/N 614-80N5070UO'Donnell Paul E · Schuylerville, NYBuilt 1980 · S/N 615-80N5070VRiney Nicholas K · Prescott, AZBuilt 1976 · S/N VAC59-76N5070XN566rm LLC · Wilsonville, ORBuilt 1968 · S/N 143N5071CWalker Rhan E · Pleasant Hill, MOBuilt 1950 · S/N D-2333N5071DAcmx LLC · Cedar Rapids, IAS/N 51171N5071GRowland Dusters LLC · Raymondville, TXS/N 1202-80N5071HFosse David K · Carbondale, ILS/N 17265329N5071JSol Aerial Surveys LLC · Las Vegas, NVBuilt 1975 · S/N 310R0191N5071KSkyview LLC · De Smet, SDS/N 348-80N5071LHill Karl D · Igiugig, AKBuilt 1967 · S/N 28-4456N5071WWallace Madison F · Thomasville, NCBuilt 1961 · S/N 28-80N5071YFletchers Aviation LLC · Mason, NHS/N 27-2085N5072CThomas Robert Allan Jr · Phoenix, AZBuilt 1978 · S/N 310R1414N5072HRiebeling Eric Herbert · Reno, NVBuilt 1975 · S/N 17265330N5072PCappurccini Alfred II · Pittsburgh, PABuilt 1958 · S/N 24-78N5072UStopka Alexis L · Belgrade, MTFirst renewal noticeBuilt 1963 · S/N 206-0072N5072VPolski Randy B · Baltimore, MDBuilt 1976 · S/N VAC-61-76N5072WHurst Randall S · Altus, ARBuilt 1961 · S/N 28-81N50731Datema Steven K · Susanville, CAS/N 21379N50733Howlett Brian A · Clarkston, WABuilt 2006 · S/N 010N5073CInternational Air Services Inc Trustee · Carson City, NVS/N EA-667N5073HElite Planes LLC · Menifee, CAS/N 17265331N5073JYork Avery C III · Crossville, TNBuilt 1975 · S/N 310R0193N5073NPavco Inc · Gig Harbor, WABuilt 1985 · S/N 17276404N5073RMckenna Brothers Aircraft LLC · Anchorage, AKBuilt 1976 · S/N 18502997N5073UMutha Fokker Aviation LLC · Wilmington, DEBuilt 1951 · S/N 21562N5073VSeaton Brad S · Cache, OKBuilt 1976 · S/N VAC-62-76N5073WPerkins Joel · Senoia, GABuilt 1950 · S/N 21096N5073YLone Star Flight Museum · Houston, TXS/N 21714N5074ATherp Todd J · Ashton, IDBuilt 1950 · S/N 21252N5074BMehrhoff Stanley E · Prairie Home, MOBuilt 1951 · S/N 21600N5074DAhumada George · Palmer, AKBuilt 1958 · S/N 51174N5074HRollins Thomas M · Salt Lake City, UTBuilt 1950 · S/N 21091N5074MFaddis Ray K · Kingwood, TXBuilt 1978 · S/N M-2051
Back to AD 2007-04-19 R1