OpenAirDocs.org
AD 56-04-01

Registered aircraft · 267

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-04-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-04-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.

N111ACCox John G · West Lafayette, INBuilt 2008 · S/N 1026-2008N116RAPreston William A · Benton Harbor, MIBuilt 2008 · S/N 1025-2008N117CASfaf LLC · Meridian, MSS/N 1008-2007N120CADodson Patrick W · Creswell, ORBuilt 2007 · S/N 1012-2007N120SGMccall Melinda · Decatur, ALS/N 1006-2006N1292HHall James E · Naples, FLBuilt 1949 · S/N 7FC-1N131RHZollars Thomas Brooke · Dallas, TXS/N 1009-2007N134JAOld School Aircraft LLC · Jackson, TNBuilt 2007 · S/N 1011-2007N137ECWessel Henry J · Lexington, SCBuilt 2007 · S/N 1016-2007N149ACOsceola Aerosport LLC · Osceola, WIBuilt 2001 · S/N 1032-2011N1511EPatton D Pettijohn · Wasilla, AKBuilt 1946 · S/N 7AC-5074N157EEschmann Tim · Novinger, MOS/N 1019-2007N157ECJones Joseph B · Newport, NCBuilt 2007 · S/N 1017-2007N164PCSkye Equipment LLC · Asheboro, NCS/N 1015-2007N167RAWojnar Ronald T · East Troy, WIBuilt 2008 · S/N 1020-2007N169RADavis John A · Cabot, ARBuilt 2008 · S/N 10242008N16BYYoung David L · Oakwood, ILS/N 47-826N1830EMeyer Scott David · Plano, TXBuilt 1946 · S/N 7AC-5397N191DPNotre Amour LLC · Cypress, TXS/N 7EC335N198ACHutton Lisa · Rising Star, TXBuilt 2008 · S/N 1028-2008N206GWOconnor Christopher G · New Haven, CTBuilt 1956 · S/N 528N2145EKrall Jeff P · Mitchell, SDBuilt 1946 · S/N 7AC-5716N21GCUer LLC · Searcy, ARBuilt 2014 · S/N 1036-2014N2215EN7396w LLC · Coeymans Hollow, NYS/N 7AC-5789N2349EWhitehawk Aviation LLC · Sanford, NCBuilt 1946 · S/N 7AC-5926N274ACWelch Thomas R · Modesto, CABuilt 2007 · S/N 1014-2007N2913KSilverman Phillip E Trustee · Fullerton, CABuilt 1946 · S/N 7EC-6496N293SABowe Joseph E DBA · Ocklawaha, FLS/N 1007-2007N299SLSatermo Lee J · New Town, NDBuilt 1947 · S/N 7CCM214N29BHShearer Glendon E · Wall, SDBuilt 1958 · S/N 215N29FFBriggs Aviation LLC · Virginia Beach, VABuilt 2008 · S/N 1022-2008N329CMGwb Air LLC · Waterford, MIBuilt 2016 · S/N 1038-2015N349ACFrets Glynn · Gainesville, GABuilt 2006 · S/N 1001-2006N35SGHoward William III · Wilson, NCS/N 1023-2007N3RJB&B Transport Inc · Omaha, NEBuilt 2008 · S/N 1027-2008N4300CBerke Steven M · Black Hawk, SDBuilt 1955 · S/N 7EC-300N4303CWhite David W · South Fulton, TNBuilt 1955 · S/N 7EC-303N4306CHarsh David L · Daniels, WVBuilt 1955 · S/N 7EC306N4308CBrooks Clifton B · Harrah, OKBuilt 1955 · S/N 7EC-308N4310CTadic Michael · Skagway, AKBuilt 1955 · S/N 7EC-310N4311CPage Aerial Service Inc · Rochelle, ILBuilt 1955 · S/N 7EC-311N4313CJohnson Charles M · Malta, MTBuilt 1955 · S/N 7EC-314N4316CNorman Shawn T · Rothsay, MNBuilt 1955 · S/N 7EC-317N4317CSasinowski Joseph Vance · Anchorage, AKBuilt 1955 · S/N 7EC-318N4318CEakins Clifford P · Bloomfield, IABuilt 1955 · S/N 7EC-323N4321CWeiss Elliott · Fresno, TXS/N 7EC-326N4322CSparrowhawk Aviation LLC · Moraine, OHS/N 7EC-327N4324CCornfield Cruisers LLC · Urbandale, IABuilt 1955 · S/N 7EC-333N4328CWelch Thomas R · Modesto, CABuilt 1955 · S/N 7EC-337N4334CEyring Joshua S · Diamond, OHBuilt 1955 · S/N 7EC-347
Back to AD 56-04-01