AD 75-07-02
Registered aircraft · 2,162
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-07-02')
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-07-02')
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-07-02') 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-07-02') 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.
N1187CNc Aviator LLC · Fuquay Varina, NCN11907Housatonic Flying Club Inc · Danbury, CTN1191CZerfas Gary B · Rockwall, TXN11937Rdt Aviation LLC · Trumbull, CTN11950Plenkers Russell A · Molino, FLN11968Good Guys Finish First Inc · Colorado Springs, CON1203CMirzaei-Nejad Hamid · Lake Stevens, WAN1205CNorthern Aire Flying Club Ltd · Black Creek, WIN12095Ciddio Mark S · Sebastopol, CAN1217MRawashdeh Osamah A · Rochester Hills, MIN121ECN121ecfllyers LLC · South Jordan, UTN1223MRussell Brian K · Phoenix, AZN122WRRangers Flying Club Inc · Eden Prairie, MNN123DSDenton Farms LLC · Williamsburg, MIN123LSBlackford Robert G · Summit Point, WVN123WEFogg Britt · Springdale, ARN1246CTriplett Michael D · Eastsound, WAN124KAJohnson Michael Scott · Edgewood, TXN1255CHaslett Lisa L · Vinita, OKN1256CC177 Heavy LLC · Colfax, NCN125JDLeppien John C · Alma, MIN1269CNovember 1269 Charlie LLC · East Montpelier, VTN1269RThompson Steve E · Port Angeles, WAN12767Lipstreu William H · Hudson, OHN127826350 LLC · Yorklyn, DEN12868Gregg William V · Greensburg, PAN1292CTrout Island Transit LLC · Glen Ellyn, ILN1294CJel Imaging Services LLC · Rochester, NYFirst renewal noticeN1296CLogan Tom B Trustee · Coeur D Alene, IDN12984Go Fly Az LLC · Gilbert, AZN12HBAerotechniques LLC · South Kent, CTN13019Plumer Eric · The Plains, VAN13061Kelly Thomas E · Tequesta, FLFirst renewal noticeN13084Lutz Kelly L · Auburndale, FLN13108Registered aircraftN13128Huffman David L · Corsicana, TXN13180Skyward Fleet Solutions LLC · Granite Bay, CAN13282Cook Thomas H · Harbor Springs, MIN13285Royalty Flight Solutions LLC · West Babylon, NYN132SMBartholet John C · Columbus, GAN13305Harbin Michael Wade · Monahans, TXN13307Burden Richard M Trustee · Woodway, TXN13314Egan Richard G · Tallahassee, FLN13342Aog Hawaii LLC · Paia, HIN13362Edwards Samuel T · Mustang, OKN13379Gittleson Vernon H · Franklin Grove, ILN13411Leiss Todd J · Merritt Island, FLN13430Mjr Assoc LLC · Bend, ORN13454Parry Matthew J · Oxnard, CAN1345CBeck Elwood M Jr · Athens, GA
Back to AD 75-07-02