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.
N4081BCooley George · Cedar Rapids, IAN4088BClinic Air Aviation Inc · Chapmansboro, TNN4090BHaun Trevor · Placerville, CAN4101BBerry Larry A · Bryan, TXN4102BLamay James R · Reno, NVN4113BRishell Charles G · Columbia, MDN4134BWildrose Aviation LLC · Victor, CAN4141BWright Eric K Sr · Wills Point, TXN4147BBaughman David W · Tijeras, NMFirst renewal noticeN4151BCraig Scott W · Sorento, ILN4205BStasson Robert K · Sikes, LAN429FSSimmons Frederick G · Lake Hiawatha, NJN505JWCampbell Matthew P · Visalia, CAN6007VHauser Scott · Towanda, PAN6556VGiannola Peter S · San Diego, CAN6575VGreeson Albert O · Moscow, KSN6578VPence Dale E · Richmond, MON6580VStassen Andrew R · Concord, CAN6583VLedger William V Jr · Shreveport, LAN6591VEpic Air Power LLC · Newark, DEN6597VGold Air LLC · Woodland Hills, CAN6624VDahle Jeffrey R · Ashland, ORN6636VMoss Herman D · Centreville, VAN666VSouthwest Viking LLC · Anthem, AZN6698VHeberlein Ronald E · Wilsonville, ORN6708VAircraft Restoration Service Enhancements LLC · Mesa, AZN68DSkaggs Randall D · Sacramento, CAN69JWWarrior Aviation LLC · Dollar Bay, MIN711LJIvie Calvin · Roanoke, TXN727TVTuskegee Eagles Of St Jeseph Mo · Agency, MON7332VLorenz William D · Benson, MNN7357VCamargo Ben DBA · Thousand Palms, CAN7392VBrown Mill Ranch LLC · Lamar, CON73DNMurdoc Aviation LLC · Destin, FLN73KPRuiz Teresa M · Lakewood Ranch, FLN746RRSolis Inc LLC · Alton, NHN74WDNevada Viking Partners LLC · Stateline, NVN77973Rentme LLC · Muskegon, MIN77EWBellanca Aviation Of Blairstown LLC · Andover, NJN77TVRauchfuss Mark A · Prescott, AZN80DECampbell Bradford D · Groton, CTN8236RBellanca LLC · Galena, KSN824KLN824kl LLC · Lakewood, CAN8254RKrejci Ryan J · Sandstone, MNN8255RTwo River Airspray LLC · Cavalier, NDN8258RNewo Aviation LLC · Garden City, KSN8265RMirrorstriker Aviation LLC · Tomball, TXN8275RRensberger Scott C · Lake Jackson, TXN8278RSutton Barry W · Longview, TXN8287RHuhnke John · Newburgh, IN
Back to AD 75-11-06