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.

N5644BSchmidt Ross A · D-63329 EgelsbachNon-citizen corporation, flight hours not reportedBuilt 1956 · S/N 33644N5644MRosenbach Jay A · Chugiak, AKBuilt 1981 · S/N 7380CN5644NTerrane Exploration & Reconnaissance Co LLC · Chandler, AZBuilt 1981 · S/N 7347CN5644QRichey Johnny · Shady Shores, TXBuilt 1965 · S/N 678N5644UDonaubauer Stefan · Charlotte, NCBuilt 1969 · S/N 28-26441N5644WHaynon Aircraft Services LLC · Palmer, AKBuilt 1980 · S/N 7350CN564514gaviation LLC · Reading, PABuilt 1973 · S/N 287305595N56453Richard G Trudeau LLC · Alto, TXBuilt 1973 · S/N 28R-73-35439N56455Boltman Erik C · Wasilla, AKBuilt 1981 · S/N 7389CN56458Arrowhead Outfitters LLC · Wasilla, AKBuilt 1982 · S/N 7400CN5645BHenderson William R · Ohatchee, ALBuilt 1956 · S/N 33645N5645DFerenczy Vincent E · Anchorage, AKBuilt 1981 · S/N 7382CN5645FReddoch Mark W Jr · Vidor, TXBuilt 1976 · S/N 28-7790133N5645PDeines E Jay · Wa Keeney, KSBuilt 1954 · S/N 24-715N5645SVictorynow LLC · Lubbock, TXS/N TE-149N5645URegistration Pending · Huntingdon, TNRegistration pendingBuilt 1969 · S/N 28-26440N56460Cessna 7870u LLC · Ottumwa, IABuilt 1973 · S/N 28-73-05596N56461Woody Aaron Michael · Cypress, TXBuilt 1973 · S/N 28R-73-35438N56462Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1982 · S/N 7409CN56463Freegard Timothy G · Phoenix, AZBuilt 1982 · S/N 7411CN5646BSkydive Ky LLC · Cecilia, KYS/N 33646N5646KSst Solutions LLC · New River, AZBuilt 1964 · S/N D-7309N5646MMaule Flight Inc · Moultrie, GAS/N 7390CN5646QGibbons Jack Lee · Alameda, CABuilt 1981 · S/N 7386CN5646UPn4 Aviation Holdings LLC · Bishop, CAS/N 28-26442N56473Registration Pending · Fort Worth, TXRegistration pendingBuilt 1973 · S/N 287325635N56474Sampson David M · Clancy, MTBuilt 1973 · S/N 28-7425003N56475Moertl Harald A · Anchorage, AKBuilt 1982 · S/N 7423CN56477Divelbiss Donald S · Fredericktown, OHBuilt 1973 · S/N 327300063N5647GDarter Lloyd R · Mountain Grove, MOBuilt 1973 · S/N 18801129N5647LFrench Rollie T · Vermillion, SDBuilt 1981 · S/N 7370CN5647PKisken Bill D · Fairbanks, AKBuilt 1982 · S/N 7422CN5647UVargas Orlando O · San Bernardino, CABuilt 1969 · S/N 28-26443N5647WAuer David A · Springfield, ILBuilt 1962 · S/N 28-804N56487Burleson Jerry H · Grapevine, TXBuilt 1973 · S/N 28-73-25639N56488Pensacola Navy Flying Club Inc · Pensacola, FLBuilt 1973 · S/N 28R-73-35444N5648BBailey Carl · Huntington, WVBuilt 1956 · S/N 33648N5648DGuhr Robert · Stockholm, NJBuilt 1982 · S/N 7418CN5648JSswb Enterprises LLC · Lufkin, TXBuilt 1974 · S/N 18263479N5648KDale James B · Skaneateles, NYBuilt 1964 · S/N D-7585N5648MBrown Gary R · Eagle River, AKBuilt 1982 · S/N 7415CN5648NAlbert Daniel L · New Athens, ILBuilt 1982 · S/N 7434CN5648QMartin Phil S · Colorado Springs, COBuilt 1965 · S/N 680N5648SWinged Warriors Aviation LLC · Doylestown, PABuilt 1966 · S/N CD-1034N5648WSpinetta Lawrence J · Austin, TXBuilt 1962 · S/N 28-807N56491Registered aircraftBuilt 1982 · S/N 7399CN56496Ics Air LLC · Saint James, MNBuilt 1973 · S/N 28-7310167N5649GMaran Properties LLC · Lowell, ARBuilt 1979 · S/N 17273564N5649KRyan Good Aviation LLC · Sioux Falls, SDS/N D-7401N5649MChesnut Lonnie R · Palmer, AKBuilt 1981 · S/N 7395C
Back to AD 2007-04-19 R1