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.

N56526Registered aircraftBuilt 1983 · S/N 7458CN56528Delzer James K · Sanger, TXBuilt 1984 · S/N 8023CN56529Jilek Peter A · River Falls, WIBuilt 1973 · S/N 34-7350346N5652CRegistered aircraftBuilt 1982 · S/N 7403CN5652ECgumps LLC · Antioch, TNBuilt 1978 · S/N 17271912N5652HKerby Ryan S · Talkeetna, AKBuilt 1983 · S/N 7447CN5652LSkelton Thomas Nichols Jr · Jackson, MSBuilt 1977 · S/N MC-533N5652NMaule Airways Inc Trustee · Wilmington, DES/N 7456CN5652ULions Flyers Inc · Enterprise, ORBuilt 1983 · S/N 7455CN5652WDamazo Kimber P · Portland, ORBuilt 1984 · S/N 8033CN56536Hurlbut Gary A · Seattle, WABuilt 1973 · S/N 28-7325653N56539Six 27 Properties LLC · Flint, TXBuilt 1990 · S/N E2539N5653BKey Jon · Seminole, TXFirst renewal noticeBuilt 1956 · S/N 33653N5653PBeasley Charles R · Lumberton, NCBuilt 1959 · S/N 24-724N5653RSchoenau Michael · Tulare, CAS/N 11001CN5653UMcclelland Robert C · La Veta, COBuilt 1969 · S/N 28-26449N5653WCrump William J · Williamstown, NJFirst renewal noticeBuilt 1962 · S/N 28-840N56545Sauder Richard J · Evergreen, COBuilt 1984 · S/N 8040CN56547Schroeder Gordon D · New Braunfels, TXBuilt 1984 · S/N 8055CN5654BStol-Air LLC · Salem, ORFirst renewal noticeBuilt 1984 · S/N 8035CN5654DMiller Arlyn E · Boise, IDBuilt 1984 · S/N 8038CN5654PLiebrecht Dennis L DBA · Ocala, FLBuilt 1959 · S/N 24-725N5654SWilcox Ryan · Brookland, ARBuilt 1966 · S/N MA-80N5654URoss Michael M Trustee · Anchorage, AKBuilt 1984 · S/N 8043CN5654VHodges Tandi R · The Woodlands, TXBuilt 1977 · S/N 28-7716190N5654WHaymes Will · Knoxville, TNBuilt 1962 · S/N 28-815N5655Phillips Mark E · Williamsville, ILS/N 28-3720N56550Holmes Peter L · Erieville, NYBuilt 1984 · S/N 8056CN56557Mannering Robert D · Warrensburg, MOS/N 11002CN56558Onlyfly LLC · Deltona, FLS/N 28-7425004N56559Waggoner Gregory · Woodward, OKBuilt 1973 · S/N 28-7405017N5655CRegistration Pending · Westford, MARegistration pendingBuilt 1980 · S/N 340A0969N5655JSale Reported · New Underwood, SDSale reported, pending cancellationBuilt 1984 · S/N 7462CN5655NWiley Aviation LLC · Saint Augustine, FLBuilt 1990 · S/N CE-1464N5655PRegistration Pending · Parkland, FLRegistration pendingBuilt 1984 · S/N 10003CN5655QJamil Mohammad Mahbub · Stockton, CABuilt 1965 · S/N 3026N5655RKavalieros James A · Bridgewater, NJBuilt 1984 · S/N 8049CN5656BBryant David L · Glendale, ORBuilt 1983 · S/N 4002CN5656EN2893e LLC · Reno, NVBuilt 1978 · S/N 17271913N5656KTompkins Wyatt M · Pearland, TXBuilt 1964 · S/N TC-756N5656PTaylor National Transportation LLC · Palatine, ILBuilt 1959 · S/N 24-727N5656SAnderson Nathan A · Soldotna, AKBuilt 1984 · S/N 4006CN5656WBennett Steven D · Durham, NCS/N 28-821N5656YD & D Airpark LLC · Anchorage, AKBuilt 1965 · S/N 18-8290N56573Knuth Matthew · Waupaca, WIBuilt 1973 · S/N 28-7405019N56578Somerset Air Service Inc · Bedminster, NJBuilt 1973 · S/N 28-7325661N5657ADaily John F · Chugiak, AKBuilt 1984 · S/N 4013CN5657KWatson Robin G · Eastsound, WABuilt 1964 · S/N D-7593N5657QRegistration Pending · Phoenix, AZRegistration pendingBuilt 1965 · S/N 3027N5657RFord Darryl · Caldwell, IDBuilt 1965 · S/N 17253287
Back to AD 2007-04-19 R1