OpenAirDocs.org
AD 78-11-01

Registered aircraft · 92

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:78-11-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:78-11-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.

N1026BBazler Jack A Trustee · Boulder, COBuilt 1956 · S/N LH-163N103BABemidji Aviation Services Inc · Bemidji, MNBuilt 1971 · S/N LD-435N103MPJoyce George E · Franklinville, NCS/N LF-50N104BABemidji Aviation Services Inc · Bemidji, MNBuilt 1965 · S/N LD-235N106BABemidji Aviation Services Inc · Bemidji, MNBuilt 1969 · S/N LD-409N107WSByers Mike L · Vista, CABuilt 1959 · S/N GH-107N110BABemidji Aviation Services Inc · Bemidji, MNBuilt 1966 · S/N LD-279N112MFMummy Mountain Med LLC · Paradise Valley, AZBuilt 1966 · S/N LP-37N117AGRegistered aircraftN-number assigned, not yet registeredS/N LP-20N131BABemidji Aviation Svcs Inc · Bemidji, MNBuilt 1966 · S/N LD-297N132BABemidji Aviation Services Inc · Bemidji, MNS/N LD-331N134BABemidji Aviation Svc Inc · Bemidji, MNBuilt 1964 · S/N LD-202N134TBKbld LLC · Buchanan, MIS/N HH-126N135BABemidji Aviation Services Inc · Bemidji, MNBuilt 1962 · S/N LD-68N142TPGeorgia Florida Aviation Search Team · Monticello, FLBuilt 1962 · S/N LF-71N144LHPaul John R · Hamilton, MTS/N RLH14N146RAerospatiale LLC · Selah, WAS/N HH-145N154LHPaul John R · Hamilton, MTS/N LH154N15PHBindon Phil E · Wasilla, AKBuilt 1958 · S/N RLH-20N184BABemidji Aviation Services Inc · Bemidji, MNBuilt 1962 · S/N LF-68N188Gear Robert Lee III · Paradise Valley, AZS/N LC70N197CANighthawk Air Systems Inc · Miami, FLBuilt 1965 · S/N LD-246N2038WYanagida Kazuaki · Norco, CABuilt 1973 · S/N LD-459N208MLAngelo Sorce Md Pllc · Dandridge, TNBuilt 1962 · S/N LF-34N218PDMoye Robert W · Saint Augustine, FLS/N LF-48N227DSL & P Air LLC · Lees Summit, MOBuilt 1957 · S/N FH-74N263CNorpoth Robert L · Circleville, OHS/N LB28N2700R-Plane Inc · Wilmington, DEBuilt 1979 · S/N 465-7N2755GOnderdonk Allyn K · Mills River, NCBuilt 1957 · S/N 57-6043N29YPeters Duane A · Anchorage, AKS/N EH-16N306DBemidji Aviation Services Inc · Bemidji, MNS/N LD-439N30AEKetting Case H · College Place, WABuilt 1962 · S/N JH-167N3274MPittsburgh Institute Of Aeronautics · West Mifflin, PAS/N 57-6061N3280ZPittsburgh Inst Of Aeronautics · W Mifflin, PAS/N 57-6080N391HHalla David M DBA · Tuscola, TXBuilt 1962 · S/N JH-164N41HWFresh Air Aviation Inc · Charlevoix, MIS/N LF73N441MCBemidji Aviation Services Inc · Bemidji, MNS/N LF 45N442MCMerrell Jon P · Wolcott, NYS/N LF 54N44MAPacific Mission Aviation · Hagatna, GUS/N LD-412N465NQueen Air Aviation Inc · Belleview, FLBuilt 1967 · S/N LC-255N46MAPacific Mission Aviation · YapBuilt 1969 · S/N LD-413N4835ZCombat Air Museum Inc · Topeka, KSBuilt 1959 · S/N LH185N499LGear Robert Lee III · Paradise Valley, AZBuilt 1961 · S/N LC-87N4RANyerges James · Midland, TXBuilt 1969 · S/N LB-4N5078EBemidji Aviation Services Inc · Bemidji, MNBuilt 1963 · S/N LF-76N5078GFresh Air Aviation Inc · Charlevoix, MIBuilt 1960 · S/N LF-8N5078NBemidji Aviation Services Inc · Bemidji, MNS/N LF-16N5078UBemidji Aviation Services Inc · Bemidji, MNBuilt 1962 · S/N LF-32N5079EBemidji Aviation Services Inc · Bemidji, MNS/N LF-52N5080GQuinlan John H DBA · Claxton, GABuilt 1962 · S/N LF-35
Back to AD 78-11-01