AD 75-09-06
Registered aircraft · 1,624
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-09-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-09-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-09-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-09-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.
N1780RDoellefeld Jason T · Langsville, OHN1789Hill Sheldon S · Minot, NDFirst renewal noticeN178VVStanley Bryan Dale · Paso Robles, CAN1790RBlack Dog Holding Inc · Pleasant Valley, NYN1792REcho Matrix LLC · Bentonville, ARN1795RBroussard Kenneth John · Lafayette, LAN1798RSedwick Jack D III · Anchorage, AKN1799RAir Support 1 Inc · Middletown, DEN17SRNcsb LLC · Anchorage, AKN1802RMontaska Management Inc · Anchorage, AKN1805Mcgarry Patrick L · Payson, AZN18118Bokman Charles J III · Athol, IDN1812RDriskell James P · Anchorage, AKN1815ROsprey Island Lodge Inc · Eagle River, AKN1816RArizona Game & Fish Dept · Phoenix, AZN1820RBarkhimer James C · Iraan, TXN1821RHoward Todd R · Minneapolis, MNN1822ROney Tony K · Anchorage, AKN1823RJones Alfred J · Friendsville, PAN1825QCree William H III · Long Beach, CAN1825RKincaid James B · Wasilla, AKN1831RC & D Aviation LLC · Brentwood, CAN1836RBc Properties LLC · Anchorage, AKN1839RBas Part Sales LLC · Greeley, CON1841RPatton Ronald V II · Keizer, ORN1847RNugent Properties LLC · Wasilla, AKFirst renewal noticeN1848QHartley Paul · Bellevue, WAN1848RTallman Dale C · Wasilla, AKN185Ellison Jeremy Trustee · Dayton, NVN18500Thompson Dennis E · Anchorage, AKN18521Island Air LLC · Eagan, MNN1852RHartman Craig T Trustee · Chugiak, AKN1856RRich Gary L · Anchorage, AKN185ABKinneen Simon N · Nome, AKN185ADDurrett Aviation LLC · Anchorage, AKN185AEDbl LLC · Hays, KSN185AFTanada Lake Lodge LLC · Grand Junction, CON185AHHattenburg Scott L · Chugiak, AKN185AJKelly Christopher · Lantana, TXN185AKFrench Joddy D · Wasilla, AKN185AMLanham Douglas S · Santa Fe, NMN185AQ2f Trade LLC · Collinsville, TXN185ARWattum Investments LLC · Kodiak, AKN185ASAdventure Bound Seaplanes Inc · Tower, MNN185AVRemote Access Aviation LLC · Saint Albans, VTN185AWVaughn Aviation LLC · Lowell, ARN185AZHeard Jesse H · Lewiston, IDN185BGibney Michael L · Bigfork, MTN185BABerk Aviation LLC · Phoenix, AZN185BBBeiter Paul R · Ellensburg, WA
Back to AD 75-09-06