AD 75-11-06
Registered aircraft · 147
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-06')
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-06')
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-06') 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-06') 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.
N8544HLaw Offices Of Timothy E Nilan A Pro Law Corp · Downey, CAN872JWWheeler Jeffrey A · Elyria, OHFirst renewal noticeN8784VSwanson Steven V · Saint Marys, GAN8798VPalmer Harvey F · Omaha, NEN8800VLong Jon M · Santee, CAN8820VDiversified Dialysis Services Inc · Lithonia, GAN8828VStebner William R · Crossville, TNN8833VMeyr Richard J · Reno, NVN8836VEast Robert W · Vancouver, WAN8862VInternational Air Services Inc Trustee · Carson City, NVN8864VAnthony Baruth · Saint Joseph, MON8868VWard Steven E · Wilbur, WAN8870VOklahoma Historical Steam Engine Museum Foundation · Oklahoma City, OKN8876VBlackburn Aviation Air LLC · Mesa, AZN8CMHoover C Michael · Spring Hill, FLN911RMSooner City Properties LLC · Dover, DEFirst renewal noticeN93486Ablamis Roger · Los Gatos, CAN93505Clark Roger D · Lubbock, TXN93541Gibbs Frederick L · Flagstaff, AZN93554Pittman Randy L · Morris, ILN93570Huffaker Kenneth Scott · Post, TXN93600Babcock Barry B · Monument, CON93641Krikorian Stephen H · Centennial, CON93657Jewett Lucas D · Helena, MTN93710Obrian Brandon · Travelers Rest, SCN9505EKelso Ted M · Fort Worth, TXN9516ESabo John D · New Lenox, ILN9522EGraham Xochitl L · Los Lunas, NMN9550EDickens James R · Diboll, TXN9578ENorton Tim C · Danville, VAN9587EFaber Theodore V · Culver City, CAN9596EKingaire LLC · Panama City, FLN9602EMerrill Mark · Ellensburg, WAN9605EMckinney James R · Saint Charles, MON9622EGilpatrick Hannah W · Las Vegas, NVN9623EHinojosa Edward · Georgetown, TXN9643EEl Gato Grande Aviation LLC · Philadelphia, PAN9685ESwanson Michael J · Wayzata, MNN9688ECool Dude LLC · Denton, TXN9733EHamilton Joe · Knowles, OKN9740EWww Bellanca US LLC · Mansfield, TXN9744EAerospace Trust Management LLC · Wilmington, DEN9776ET2tc LLC · Enka, NCN9778EFrazier Lance C · Round Rock, TXN9781EZielinski Alan D · Vlg Of Lakewd, ILN9783ECross Joseph Eugene · Arlington, VAN999MTColwell Ronald F · Carmel, IN
Back to AD 75-11-06