AD 75-17-36
Registered aircraft · 148
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-17-36')
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-17-36')
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-17-36') 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-17-36') 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.
N3738HMccoy Timothy I · Pittsburgh, PAN3742RMaier Craig S · Crystal Lake, ILN3746ELorenz Douglas A · Littleton, CON3750ARogers Brandon M · Phoenix, AZN37519Lynch William J · Granby, MON3762LJames Steve W · Savannah, MON3764FBalloons Over Iowa Ltd · Carlisle, IAN40371Bowman James A · Oklahoma City, OKN4037JBookman Benjamin I · Colorado Springs, CON4038RBalloons Over Iowa Ltd · Carlisle, IAN4038UEdwards Jeremy · Marietta, GAN4039GRutan Aaron R · Greentown, INN4039QRadloff Mark W · Argyle, NYN4040LHill Martin Jr · Centennial, CON40427Word D Glen · Anthony, NMN4042DMile High Aeronauts Inc · Littleton, CON4042KHalling Wayne C · Ceresco, NEN4043YHall Bruce M · Kenwood, CAN4044EDezmelyk Robert · Newton, NHN4044WThornton Ronald D · Littleton, MAN4047TShady Gail Ann · Casper, WYN40501De Koevend Enterprises Inc · Fort Garland, CON40518Vande Hoef Raymond L · Greeley, CON4051TLombardi Marcia M · Bristol, CTN4052JFlameboyant Balloons LLC · Easton, PAN4052TLeonard Ian Q · Burlington, NCFirst renewal noticeN4053YIhle Ronald W · Slater, IAN4054STerranova-Anderson Deirdre P · Norman, OKN4057GBoyd Robert T · Quakertown, PAN40585Shady Raymond · Casper, WYN4061VKotecki Thomas G · Muskego, WIN4065KHoffman Jeffrey W · Ringoes, NJFirst renewal noticeN40672Fleck Jonathan D · Whitehouse Station, NJN4069DGallagher Douglas L · Albuquerque, NMN4070KPata John · Rio Rancho, NMN4071TUniversity Of Central Missouri · Warrensburg, MON4200PGreen Robert H · Elfin Forest, CAN469PKLiley Brian A · Fall Branch, TNN48JDCline J Donald · Greensboro, NCN5182UScott Michael R · Rio Rancho, NMN7103BBalloon Detail Inc · Norwich, NYN7105HHarbold Clarke D · Charlotte, NCN7105KDunn Jason A · Galesburg, ILN71063Get High Incorporated · Longview, TXN7106RGoodson Andrew J · Oxford, MIN7106XVezzosi Rosalie I · Milford, NJN7114GParrish Johnathon G · Toney, ALN71159Mccalla Darrell P · Mountain Brook, ALFirst renewal noticeN7115HMakhlouf Mary H · Hurdle Mills, NCN7117CBliss Stephen D · Norwich, NY
Back to AD 75-17-36