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.

N2664LAce Airways LLC · Quincy, WABuilt 1980 · S/N 414A0535N2664MInfcon LLC · Wilmington, DEFirst renewal noticeS/N E-2317N2664UHill Flying Club Inc · St George, UTBuilt 1998 · S/N 18280298N26655Weyhe Joan Monica · Medford, ORBuilt 1978 · S/N AA5A0623N2665CWindsock Skies LLC · Caldwell, TXBuilt 1978 · S/N R18200201N2665MProsser William C · Wasilla, AKBuilt 1947 · S/N 12-993N2665ZRegistered aircraftBuilt 1978 · S/N 351-78N26661Barber William M · Alden, MIBuilt 1978 · S/N AA5A0547N26664Grumman N26664 LLC · Charlotte, NCBuilt 1977 · S/N AA5A-0518N2666GForward Logistics LLC · New Castle, VABuilt 1959 · S/N 51966N2666PBerentson Bradley J · Westhope, NDBuilt 1955 · S/N 18-4390N2666QCloos Randy J · Osburne, IDBuilt 1966 · S/N 18257866N2666TNess Ronald O · Canyon Lake, CABuilt 1971 · S/N 28-7210002N2667Marlow Air LLC · Gilmanton Iw, NHBuilt 1965 · S/N D-7997N26670Ward John L · Mexia, TXBuilt 1978 · S/N AA5A0628N26675Kilmurry Thomas · Charlotte, NCBuilt 1978 · S/N AA5A0639N26679Kennann Christopher D · Lubbock, TXS/N AA5A0641N2667BBellanca Flyer Inc · Winter Garden, FLBuilt 1988 · S/N 89-301002N2667FVan Hooser Barry S · Pleasanton, CABuilt 1965 · S/N 18256767N2667GTundra Aviation Inc · Casselton, NDS/N 51967N2667MYce Consulting Inc · Easton, PABuilt 1989 · S/N 89-301008N2667RJorgensen Larry C · Randle, WABuilt 1967 · S/N 18258367N2667SMarcum Aviation Maintenance Services LLC · Galena, OHS/N 21061347N2667WMartens Steven A · Stanley, NDBuilt 1966 · S/N 670024N2667ZHite Loren E · Fairbanks, AKBuilt 1978 · S/N 264-78N26684Stanard Paul J · Moreland Hills, OHBuilt 1978 · S/N AA5A0644N26685Le Pendu Claude E · Fruit Heights, UTBuilt 1978 · S/N AA5A0645N26688Kirker Edmund J · Omaha, NEBuilt 1978 · S/N AA5A0647N2668ASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1981 · S/N 421C1216N2668FBreaux Robert R · Chino Hills, CABuilt 1965 · S/N 18256768N2668GGospel Ministries International · Mc Donald, TNBuilt 1959 · S/N 51968N2668PRegistered aircraftBuilt 1955 · S/N 18-4392N2668RCummings Robert S · Bowling Green, KYBuilt 1967 · S/N 18258368N2668TKing Thomas S · Boerne, TXBuilt 1971 · S/N 28-7205092N2668WJarchow John H · Denison, TXBuilt 1966 · S/N 993N26691Stuckenschneider Robert J · Sedona, AZBuilt 1978 · S/N AA5A0648N26692Fields Douglas P Jr · Brooklyn, NYBuilt 1979 · S/N 310R1849N26693Truszkowski Donald J · Wyandotte, MIBuilt 1978 · S/N AA5A0649N26695Drude Kris A · Dayton, OHBuilt 1978 · S/N AA5A0651N26696Provincetown Pilots Group Inc · Provincetown, MABuilt 1978 · S/N AA5A0652N2669FMichelbrink Hunter J · Gardiner, MTS/N 18256769N2669NWilliamson Benjamin J · Morgan Hill, CABuilt 1979 · S/N 340A0735N2669PLegends LLC · Willow, AKBuilt 1955 · S/N 18-4393N2669QBanks Ron E · Blanchard, OKBuilt 1966 · S/N 18257869N2669RStrubhar Wesley D · Foster, ORBuilt 1967 · S/N 18258369N2669TCity Of Westfield · Westfield, MAS/N 28-7225082N2669WAlecci Alexander Drew · Sanford, FLBuilt 1966 · S/N 994N2669XSkydive Ricks LLC · Petersburg, OHBuilt 1965 · S/N P206-0169N2669YHession Mark A · Arrington, TNBuilt 1962 · S/N 18051169N266AAFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881760
Back to AD 2007-04-19 R1