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.

N5470DDocter Lloyd W · Tacoma, WABuilt 1957 · S/N D-5020N5470KSkye Aircraft LLC · Deland, FLBuilt 1980 · S/N 17274136N5470WRegistration Pending · Bulverde, TXRegistration pendingBuilt 1962 · S/N 28-551N54715Apt Aero LLC · Port Angeles, WABuilt 1981 · S/N 17275038N5471BLowenstein Jeffrey · Juneau, AKBuilt 1956 · S/N 33471N5471DN5471d LLC · Duluth, MNBuilt 1957 · S/N D-5006N5471GGlenn William · Hilton Head Island, SCBuilt 1978 · S/N E-1338N5471LJc Investors Group LLC · Coral Springs, FLBuilt 1973 · S/N AA5-0371N5471NRiley Aviation LLC · Columbia, TNBuilt 1980 · S/N 18267741N5471PN5471p LLC · Roswell, GABuilt 1958 · S/N 24-528N5471WBartholomew Charles Scott · Newburyport, MABuilt 1962 · S/N 28-552N54728Vig Cheryl J · Opal, SDS/N 17275039N5472HBertrand Joel R Trustee · Anchorage, AKBuilt 1950 · S/N 18-64N5472RAnderson Craig D · Mission Viejo, CABuilt 1974 · S/N 17263544N5472TAdvantage Aviation Inc · Palo Alto, CABuilt 1972 · S/N 28R-7235234N5472VGivens Thomas A · Southern Pines, NCS/N 21410N54733Gofastpilots LLC · Roswell, NMBuilt 1981 · S/N 17275042N54734Southern Arkansas University Tech · Camden, ARS/N 17275043N54739Skylens LLC · Hammond, LABuilt 1981 · S/N 17275045N5473ABoisseau Guy M · Gulf Breeze, FLBuilt 1958 · S/N 35673N5473BWalsh David P Jr · Macon, GABuilt 1956 · S/N 33473N5473DN1705r Inc · Cobb, CABuilt 1979 · S/N 17272579N5473HSkatvold Charles P · Moorhead, MNBuilt 1950 · S/N 18-63N5473LPlane Fun Inc Tr Trustee · Snellville, GABuilt 1973 · S/N AA5-0373N5473NVan Wagenen Robert F · Watsonville, CABuilt 1980 · S/N 18267743N5473PBloyer Kelly G · Townsend, GABuilt 1959 · S/N 24-530N5473TTiernan Barton M · Anchorage, AKBuilt 1982 · S/N R18201876N5473WMathews Derek A · Burlington, KYBuilt 1962 · S/N 28-555N54741State Of Alaska · Anchorage, AKBuilt 1976 · S/N 18-7609052N54744Suncoast Aviation Of Swfl LLC · Fort Myers, FLBuilt 1981 · S/N 17275047N5474JRedick Albert L II · Reno, NVBuilt 1975 · S/N 310R0272N5474PKrnp Air Services LLC · Zeeland, MIBuilt 1958 · S/N 24-531N5474SHiggs Mark P · Monett, MOBuilt 1971 · S/N 28-7125128N54750Heartland Aviation Inc · Alliance, NES/N 18-7609053N54752Aerosync LLC · Miami, FLBuilt 1981 · S/N 17275048N54757Pacific Fleet Aviation LLC · Rochester, NYBuilt 1975 · S/N 27-7554068N5475DDelta Ridge Farms LLC · Oak Grove, LAS/N D-4994N5475HRouth Frank D · Marion, NCBuilt 1975 · S/N 17265459N5475NJoe Dory Aviation LLC · Star, IDBuilt 1980 · S/N 18267745N5475URennie Leonard C · Glenn Dale, MDBuilt 1967 · S/N CD-1121N5475WWing & A Prayer LLC · Moreland, GABuilt 1962 · S/N 28-557N54763Kinneen Fen T · Nome, AKS/N 18-7609054N5476LCameron Alan S · Bealeton, VABuilt 1973 · S/N AA5-0376N5476UMagruder Thomas D Jr · Ocean Springs, MSBuilt 1967 · S/N TC-1037N5476WTalon Aviation LLC · Greenville, MIBuilt 1962 · S/N 28-558N5476YAltura Aviation 2 LLC · Charlotte, NCBuilt 1980 · S/N 21064219N5477Hudson Lake Properties LLC · Pryor, OKBuilt 1956 · S/N 33477N5477LAa5a Flyers · San Diego, CABuilt 1973 · S/N AA5-0377N5477WAchi Inc · San Jacinto, CABuilt 1962 · S/N 28-559N54781Kingsky Flight Academy LLC · Lakeland, FLBuilt 1981 · S/N 17275051
Back to AD 2007-04-19 R1