AD 56-06-01

Registered aircraft · 15,143

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:56-06-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:56-06-01')
  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.

N1052MFendt Alan D Trustee · Dexter, MIBuilt 1975 · S/N 18264216N10554T34sum LLC · Lake In The Hills, ILS/N CCF-34-37N1055MRyan Michael W · Long Beach, CABuilt 1975 · S/N 18264217N105BMatthews George W · Hillsboro, OHBuilt 1956 · S/N D-4399N105ERSokoloski James J · Lampasas, TXBuilt 1947 · S/N NAV-4-521N105MTRegistered aircraftBuilt 1976 · S/N 182-64338N105SPDepartment Of Emergency Svcs & Public Protection · Hartford, CTBuilt 1984 · S/N 18268425N105VBHughes Francis A · Ltl Egg Hbr Twp, NJBuilt 1981 · S/N 18268138N1069Byrne Sofia V · Merrimack, NHBuilt 1948 · S/N NAV-4-1775N1069LWilson Michael A · Everett, WABuilt 1956 · S/N 33633N106BAnderson Martino G · Lakeland, FLBuilt 1955 · S/N D-4394N106NChenevert Eric M · Clarence, NYBuilt 1962 · S/N D7035N106PSScarrow James D · Jerome, IDBuilt 1976 · S/N 18264800N106RGCadena Edward R Jr · Houston, TXBuilt 1966 · S/N 18257535N106UMiha LLC · Dover, DEBuilt 1956 · S/N 32325N10714Tennessee Museum Of Aviation · Sevierville, TNBuilt 1951 · S/N 22748N10715Noyes Stephen S · Newburyport, MABuilt 1951 · S/N 22816N1073MScr Aviation LLC · Austin, TXBuilt 1975 · S/N 18264219N1077B85 Alpha Inc · Wilmington, DEBuilt 1957 · S/N D-4931N107SPDepartment Of Emergency Svc & Public Protection · Hartford, CTBuilt 1984 · S/N 18268427N107WFWilcox Farms Inc · Roy, WABuilt 1961 · S/N 18253149N107YYBeezhold Terence J · Lake Stevens, WABuilt 1956 · S/N 35266N1080MFlying Particles Inc · Livermore, CABuilt 1977 · S/N 18266034N1082PGarrett James D Jr Trustee · Coolidge, AZBuilt 1968 · S/N 18258855N1084WLafayette Foundation Inc · Fort Lupton, COBuilt 2019 · S/N C1084N1085MDuncan Terry C Trustee · Cupertino, CABuilt 1975 · S/N 18264221N1086LLade Burton G · Bemidji, MNBuilt 1959 · S/N 50564N1086MSargent John E · Vancouver, WABuilt 1975 · S/N 18264222N1089MPetersen Clayton · Albert Lea, MNBuilt 1975 · S/N 18264223N108BCaturia Jeffrey T · Layton, UTBuilt 1955 · S/N D-4397N108BTFlying J Aviation LLC · Lynden, WABuilt 1948 · S/N 108-4045N108EENorthwood Services Inc · Skwentna, AKBuilt 1956 · S/N 32505N108GWPope James D · Clarkston, WAS/N 32683N108KDPayne Steven H · Nine Mile Falls, WABuilt 1949 · S/N 1084963N108RMFernandez Taylor R · Wasilla, AKBuilt 1948 · S/N 108-5257N108SPDale County Sheriffs Office · Ozark, ALS/N 18260052N108TTTurnbull Archie · Ypsilanti, MIBuilt 1946 · S/N 108-534N1090MBergstrom Aircraft Inc · Pasco, WAS/N 18264224N10948Morris Jacky D · Watonga, OKBuilt 1977 · S/N 18266102N109AKHarris Eric W Jr · Moncks Corner, SCBuilt 1956 · S/N D-4464N109DSBell Bradley L · Bothell, WABuilt 1948 · S/N NAV-4-1373N109FRoos Patrick R · Purcellville, VABuilt 1947 · S/N NAV-4-839N109WYPerala Daniel R · Cheyenne, WYBuilt 1969 · S/N 18260131N109YBraun Joshua S · Port Hope, MIBuilt 1962 · S/N 18253513N10EVCafiero Vincent · Haskell, OKBuilt 1955 · S/N D-4186N10GCBanks Keith Allen · Salisbury, MDBuilt 1953 · S/N 30159N10GGMartinelli Alexander Joseph · Waco, TXBuilt 1947 · S/N D-1065N10JFRempert Erich A · Lake Geneva, WIS/N NAV-4-1391N10JHHayden Charles J Jr · Richmond, TXBuilt 1973 · S/N 001N10RRLeonard Christopher S · Moravia, NYBuilt 1954 · S/N D-3706
Back to AD 56-06-01