AD 75-01-07
Registered aircraft · 2,118
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:75-01-07')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-01-07')
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:75-01-07') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-01-07') 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.
N389SLively Kirk D · Cresson, TXN38DKCullinan Robert B · Rch Palos Vrd, CAN390HWRojecki Stephen T Trustee · Navarre, FLN3910ARzepka Rick · Solon, OHN392SPlocher Corey · Port Orchard, WAN3952ARegistered aircraftN3957ARegistration Pending · Denton, TXRegistration pendingN3958AHinton Richard D · Colleyville, TXN398LTHogan William · Deer Lodge, MTN399PTDethomas John V Trustee · Boise, IDN3BGHildreth James D · Kennedy, ALN3BRSouthern Aircraft Consultancy Inc Trustee · Casper, WYN3BW4rc LLC · Kenedy, TXN3DXMchugh Michael J Trustee · Hailey, IDN3HFHughes Farms Inc · Fayette, MON3JWJason Flood · Vineland, NJN3MDMcdavid James J · Weatherford, TXN3MYLee Brian E · Peoria, AZN3SVYoung Karen Sue · Cincinnati, OHN3XTHammock Jerry G · Waxahachie, TXN4004APrice Jason R · Lillington, NCN400LFBoboltz Randy · Hector, MNN400PBonanza V35 LLC · Bakersfield, CAN400RCSpiwak Andrew J · Canyon Lake, TXN400VHalford John · Ballinger, TXN400WEOberti Gary A · Hillsborough, CAN4010ARegistered aircraftN4013AGeoghagan Dewayne · Indianapolis, INN4042ARogden Aviation Inc · San Rafael, CAN4043AByard Jeffrey G · Carson City, NVN4045AWdw Aviation Leasing Inc · Knoxville, TNN404MDDent Thomas E · Moses Lake, WAN4059SKramer Harvesting LLC · Johnson, KSN406TLevel Wings LLC · Jefferson City, MON406WCCebulski Wade E · Seeley Lake, MTN4077AFarmer Gary E · Saint Augustine, FLN4080SCosse John J Jr Trustee · Lenexa, KSN4083A4083a LLC · Wilmington, DEN4084CKrech Gordon L · Rolla, NDN4084SDavenport Michael · Naperville, ILN4086APippert James R · Dysart, IAN4086S80'S Associates Inc · Pittstown, NJN4089SRaii3 LLC · Lewes, DEN409MFenton Richard O · Weatherford, TXN409SSBlackwell Aviation Inc · Bell Vernon, PAN40GHagerty Environmental LLC · Kennett Square, PAN40GMSteven E Cox · Bend, ORN40KTDemuth Gabriel J · Jackson Springs, NCN4107SAnnamar LLC · Wilmington, DEN411EGCompton William C · Anchorage, AK
Back to AD 75-01-07