AD 75-11-01
Registered aircraft · 138
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-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:75-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.
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-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:75-11-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.
N3304QMcnutt Brian K · Mojave, CAN3308QDodson International Parts Inc · Rantoul, KSN3309QB & R Aerial Crop Care Inc · Connell, WAN3315QTcf Ventures LLC · Wilmington, DEN3316QPerson Michael · West Chester, PAN3317QSkynight 17q LLC · Roseville, CAN3318Q2400 Rickenbacker LLC DBA · Auburn, CAN3319QNeuschaefer George H · White Hills, AZN3325QWinrick LLC · Flagstaff, AZN33UPAero Valley Properties LLC · Roanoke, TXN3405QHardin David A · Tukwila, WAN3412QPoulsen Melvin J · Orem, UTN3417QGholami Amir H · Santa Rosa, CAN3437QJamerson Kendall L · Bovina, TXN3444QKeystone Aerial Surveys Inc · Philadelphia, PAN3452QGolden Arrow Transportation Co · Plainfield, NJN3458QIngram John · Los Angeles, CAN3474QLyle Timothy · Lakewood Ranch, FLFirst renewal noticeN3478QCsc Aviation LLC · Parker, CON3489QPlane Progress LLC · Waterloo, IAN3491QOuter Marker Inc · Sandy, UTN3492QLadet William D · Las Vegas, NVN3494QRodcon Aircraft Sales LLC · Kalispell, MTN3495QBoswell Alan · Chrisney, INN372JCompass Rose Services Inc · Powell Butte, ORN398PGeorge Monte C · Ashland, ORN3VBHarrison Ted W · Grapevine, TXN4078QGerker Carl J · Palmdale, CAN4123TRace Dean · Chicken, AKN4130TSteven J Leavitt · Avondale, AZN4135TNehls Chevrolet Olds Cadillac · Marshall, TXN4138TLindquist Holdings LLC · Noblesville, INN4154TNunya Business LLC · Middletown, DEN4156TRichard Brady K · Farmers Branch, TXN4159TGholami Amir H · Santa Rosa, CAN4163TKasper Heath · Albany, ORN4181TKeystone Aerial Surveys Inc · Philadelphia, PAN4186TRegistered aircraftN4207NHoover Brian A · Warsaw, INN420WBMcgregor Springs Square LLC · Mc Gregor, TXN4500VBales Philip J · Chandler, AZN5207XGreat Oaks Cdc · Cincinnati, OHN543MPayne Jon R · Danville, PAN566AGarrett Flying Service Inc · Danbury, TXN56VPGoulette Bryan · Fort Worth, TXN5701XCoan Mark A · Berthoud, CON5714XKulon Andrew · Wyanet, ILN5716XFlanegan Charles E Jr · Jonesboro, GAN5721XRichardson John L · Anchorage, AKN5731XLife Is Flying Inc · Deerfield Beach, FL
Back to AD 75-11-01