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.
N7120XFisher Craig D · Wellington, CON7121MRiley Theron A · Columbia, MON7122NNorth Carlina Ballon Museum · Statesville, NCN7122ZLeisek John C · Tooele, UTFirst renewal noticeN71235Miller Royce D · Guymon, OKN7125JPennell Mark G · Sparta, NCN7125ZOgland Peggy A · Long Lake, MNN7126BTucker Lynn · Orlando, FLN7127KNew Beginnings Balloon LLC · Plymouth, MIN7405USeeger Kenneth A · Travelers Rest, SCN74063De Young Robert E · Napa, CAN74068Dunavent Duncan R · Statesville, NCN74071Hill Martin Jr · Centennial, CON7408GBoucher Jason D · Chester, NHN7408LMeteyer Richard · Davisburg, MIFirst renewal noticeN7413HWise Nicki · Statesville, NCN74145Leonard Michael A · Johnson City, TNFirst renewal noticeN7414BDowney Lawrence C · Des Moines, IAN7414TGale Timothy M · Albany, ORN7415QGreen Robert H · Escondido, CAN7415SMorris Gunnar Von · Carl Junction, MON74168Aglar Daniel P · Agate, CON7417LKirk Chad Justin · Zebulon, NCN7417UDe Koevend Enterprises · Fort Garland, CON74196Graham Keith P · Alta Loma, CAN74202Raciborski Donald J · Harvard, ILN74207Michael Larry S · Indianola, IAN7421DKozlowski Johnnie Ryan · Albuquerque, NMN7423DLitton David B · Statesville, NCN7423WWay Michael Charles · Garberville, CAN752MJJurhill Molly Parker · Scottsdale, AZFirst renewal noticeN8039HBowlander Franklin G · Clinton Corners, NYN86GTLudlow David J · Toledo, OHN90014Albertson James M · Westville, FLFirst renewal noticeN90016Usrey Lea · Casper, WYN90058Babeck Robert J · Wendell, NCN9007QHunter Matthew P · Lake Wales, FLN90224Laudick Robert G · Denver, CON9044QThornton Ronald D · Littleton, MAN90555Holt Charles Glen · Natchitoches, LAN90601Weatherproof Montana LLC · Missoula, MTN9067FCortright Justin L · Endicott, NYN9069NMott Terry W · Hampton, IAN9075FBrielmann Kevin C · Cromwell, CTN9077SConverse Karen E · Albuquerque, NMN90883Campbell Harold G · Lorenzo, TXN9089KDekoevend Enterprises · Fort Garland, CON9091EF B Howes 111 · Colorado Springs, CO
Back to AD 75-17-36