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.
N1473FSilveira Paul J · Valdez, AKN1475FAc Group LLC · Helena, MTN14PHHuman Lee · Mercer Island, WAN151PBParker Scott L · Midland, TXN1551QJdn Plane LLC · Bellevue, WAN1556MC-Fleet LLC · Missoula, MTN156KCWhitney Aviation LLC · Derry, NHN1576HBloom Timothy S · Chugiak, AKN1577HKing Wayne T · Anchorage, AKN1582QWhite William Wayne · Corona, CAN1588MAnderson Aerial Spraying Service Inc · Canby, MNN158RXMurkowski Francis M · Anchorage, AKN1598HCarey Philip J Trustee · Wasilla, AKN1599MRegistered aircraftN1613MMclaughlin Drew V · Anchorage, AKN1618MFluckey Gary T · Homer, AKN1624HSynergy Aviation LLC · Forest Lake, MNN1644MBrown James E · Duluth, MNN165DBCloud 916 LLC · Dover, DEN165DFMarks James E · Valatie, NYN1662RGray Jerry B · Valdez, AKN1663RSmith Dan V · Anchorage, AKN1667MTen Mile Ranch Inc · Vale, ORN1669MC Y Transport LLC · Columbus, MNN1671RDavis Ronald L Jr · Soldotna, AKN1673MBower Ashley R · Anchorage, AKN1675MWenk Peter J · Ocala, FLN1677RYarger Denim B · Laurel, MTN1678RPureflight Aviation Training LLC · Newberg, ORN1679MVaughns Flying Service Inc · Reese, MIN1686MTerrastar LLC · Kalispell, MTN1690RFederal Aerial Applicators LLC · Wilmington, DEN1692MClark Shawn W · Anchorage, AKN1694MWraith Lane T · Wasilla, AKN1694RCrow Rock LLC · Stillwater, MNN1701RM R Planes LLC · Redmond, WAN1708RHall Alan D Trustee · Big Bear Lake, CAN1718RStripe Joseph · Olympia, WAN1726RPetumenos Timothy J · Anchorage, AKN1728RIcenogle Roger A · Inver Grove, MNN1743RChronicle Aerospace Inc · Wilmington, DEN1745RFiske James K · North Andover, MAFirst renewal noticeN174LSN174ls LLC · Middlebury, CTN1750RShort James B · Anchorage, AKN1756RMontana Rose 185 LLC · Cornwall, VTN1767RHamel David A · Klamath Falls, ORN1769RCt Aviation LLC · Waverly, NEN176TCRedtail Cirrus LLC · Boise, IDN1770RRegistered aircraftN1775RAnderson Lenny R · King Salmon, AK
Back to AD 75-09-06