OpenAirDocs.org
AD 79-01-02 R2

Registered aircraft · 177

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

N261BWinnie Mae Inc · Tallahassee, FLBuilt 1957 · S/N DH-134N263CNorpoth Robert L · Circleville, OHS/N LB28N270Young Aviation LLC · Panama City, FLBuilt 1961 · S/N DH-308N2700R-Plane Inc · Wilmington, DEBuilt 1979 · S/N 465-7N2755GOnderdonk Allyn K · Mills River, NCBuilt 1957 · S/N 57-6043N28ECZefting Aviation LLC · Bellingham, WABuilt 1960 · S/N DH-285N295DEFly Direct LLC · La Porte, INBuilt 1956 · S/N DH-88N29YPeters Duane A · Anchorage, AKS/N EH-16N306DBemidji Aviation Services Inc · Bemidji, MNS/N LD-439N30AEKetting Case H · College Place, WABuilt 1962 · S/N JH-167N311DDSierra Aeronautics LLC · Gambier, OHBuilt 1960 · S/N DH-311N3274MPittsburgh Institute Of Aeronautics · West Mifflin, PAS/N 57-6061N3280ZPittsburgh Inst Of Aeronautics · W Mifflin, PAS/N 57-6080N333BQQualitair LLC Trustee · MichelstadtBuilt 1960 · S/N DH-250N3564BMach 4 Missions · Middleton, TNBuilt 1954 · S/N CH-114N356TRegistered aircraftBuilt 1960 · S/N DH-270N35MCWallace James W · Elkins, WVBuilt 1955 · S/N CH-177N360KRRyans Float Flying LLC · Oregon City, ORBuilt 1961 · S/N DH-320N3653BPlacebo Air LLC · Ridgecrest, CABuilt 1954 · S/N CH-128N3722BRui C LLC · Reddick, FLBuilt 1955 · S/N CH-152N3743BPittsburgh Institute Of Aeronautics · West Mifflin, PABuilt 1955 · S/N CH-169N3755BYazdi Navid D · Beaverton, ORBuilt 1955 · S/N CH-195N3775BMummy Mountain Med LLC · Paradise Valley, AZBuilt 1955 · S/N CH-187N3784BOgorek Peter J · Milwaukee, WIBuilt 1955 · S/N CH-200N3795BCanyon Aero LLC · Fresno, CABuilt 1955 · S/N CH-302N37WBSterling Aviation Services Inc · Wilmington, NCBuilt 1955 · S/N CH-161N38MMMusko Richard M · Wilkes Barre, PABuilt 1955 · S/N CH-297N391HHalla David M DBA · Tuscola, TXBuilt 1962 · S/N JH-164N41DEOhlwiler Eric D · Oviedo, FLBuilt 1955 · S/N CH-305N41HWFresh Air Aviation Inc · Charlevoix, MIS/N LF73N4306DNightingale Matthew M · Rancho Cucamonga, CABuilt 1956 · S/N DH-65N434TAir Tebsin Twinbo LLC · Lewistown, MTBuilt 1960 · S/N DH-306N4357DStychworks LLC · Palmer, AKBuilt 1956 · S/N DH-122N441MCBemidji 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 LH185N4946BTippetts Kelly · Richmond, KSS/N CH-346N4948BKrause Aviation LLC · Geneva, ILBuilt 1955 · S/N DH-4N499LGear Robert Lee III · Paradise Valley, AZBuilt 1961 · S/N LC-87N4RANyerges James · Midland, TXBuilt 1969 · S/N LB-4N4TB367 Estrella LLC · Ponte Vedra Beach, FLBuilt 1955 · S/N CH-308N5078EBemidji 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 79-01-02 R2