AD 79-13-01
Registered aircraft · 109
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-13-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:79-13-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.
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-13-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:79-13-01') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N3755BYazdi Navid D · Beaverton, ORN3775BMummy Mountain Med LLC · Paradise Valley, AZN3784BOgorek Peter J · Milwaukee, WIN3795BCanyon Aero LLC · Fresno, CAN37WBSterling Aviation Services Inc · Wilmington, NCN38MMMusko Richard M · Wilkes Barre, PAN391HHalla David M DBA · Tuscola, TXN41DEOhlwiler Eric D · Oviedo, FLN4306DNightingale Matthew M · Rancho Cucamonga, CAN434TAir Tebsin Twinbo LLC · Lewistown, MTN4357DStychworks LLC · Palmer, AKN4835ZCombat Air Museum Inc · Topeka, KSN4946BTippetts Kelly · Richmond, KSN4948BKrause Aviation LLC · Geneva, ILN4TB367 Estrella LLC · Ponte Vedra Beach, FLN50HTDunteman William M · Big Rock, ILN536DShiloh Aviation LLC · Ramer, TNN58KSMid-Atlantic Aircraft Leasing LLC · Wilmington, DEN5FPittsburgh Institute Of Aeronautics · Pittsburgh, PAN5GYSeven Sierra Yankee LLC DBA · Monroeville, PAN602PPayne Mark Robert Jr · Germantown, TNN611DRK & A Solutions LLC · Summerfield, NCN61TBJay Travis · Vero Beach, FLN627BMGist Brett · Poolville, TXN628ZGlantz Richard L · Whitefish, MTN632ZReady Aim Flyer LLC · New Castle, DEN66QMSammons Shaun W · Memphis, TNN697TMilguard Aviation Corp · Wilmington, DENon-citizen corporation, flight hours not reportedN7055MPaul John · Hamilton, MTN721BStandel David · Jacksonville, FLN738WBNord Aviation Inc · Pembina, NDN76LThacker Flying Club LLC · Griffin, GAN773AGSky West Aviation Inc Trustee · Albuquerque, NMN7770XT Bone Air LLC · Missoula, MTN787SCSilverthorne Adam · Walnut Creek, CAN80TBGraphite Consulting Inc · Woodland, CAN811ACUnited States Construction Corp · Pompano Beach, FLN814JEEasca LLC · Little Rock, ARN816DSAdcock Raymond D · Cabot, ARN824GFDavis Aviation Inc · Brandon, MSN82SPMaiden Robert · Williamson, GAN833QShiloh Aviation LLC · Ramer, TNN850BCadieux Gregg M · Scotia, NYN85MCFrasier Samuel R · Gainesville, FLN85TMErwin Matthew Lee · Georgetown, INN872GMWilliams Tod C · Sheffield, MAN888BSFrasca Thomas W · Champaign, ILN918SNorton Wesley R · Medford, ORN925DJErvin Joshua C · New Plymouth, OHN92HBDawe Jon · Collierville, TN
Back to AD 79-13-01