AD 75-09-08
Registered aircraft · 3,035
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-08')
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-08')
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-08') 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-08') 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.
N188DHDunworth Jack R · Rutledge, GAN188GHAer Lightfoot LLC · Alpena, MIN18JKTalley Warbirds Inc · Longview, TXN1900YMarrero Francisco J · Lake Charles, LAN1902YFlowers John H · Laurel, MSN1909YDuncan Lori Ann · New Tazewell, TNN1910YPeabody Riley A · Minnetonka, MNN1912YFrokjer Dean C · Saint Croix Falls, WIN1913YSchmitt William Joseph · Santa Cruz, CAN1915YJordan S Connor · Elizabeth City, NCN1916YLarsen Adam P · Gresham, ORN1917YMock Joseph R · Huntsville, TXN1919YSu Ryan · Saint Augustine, FLN191ABRegistration Pending · Newport, ORRegistration pendingN191DJScallion Leon Ivy · Pine Bluff, ARN191HCTrinair Aviation LLC · Hampshire, ILN191PALa Mooneytte LLC · Seabrook, SCN1920CVanjara Gufran U · San Ramon, CAN1922YDurso Joseph M Jr · Mesa, AZN1923YHyde Joe G · San Angelo, TXN1924YHull Thomas · Midland, TXN1925YMapes Peter B · Oscoda, MIN1926YRoss Dustin · Georgetown, TXN1928YMaddex William E · Battle Ground, WAN1932YDriver L Spence · Bay City, WIN1934YMack Anita · Scott Afb, ILN1935YHodges William L Jr · Spotsylvania, VAN1937YTirado Josue · Pembroke Pines, FLN1939YMcconnell Kristopher P · Nampa, IDFirst renewal noticeN193DRLinden Elizabeth M · Mc Farland, WIN1940YMiller Rollie R · Dillon, MTN19411Taylor Fred H · Plano, TXFirst renewal noticeN1944YHolcombe Thomas Hg · Moss, TNN1946YTrimmer Benjamin M · Tomball, TXN1948YGregory Michael Rybarczyk · West Chester, OHN1949YHawkins Robert A · Lake Butler, FLN1952YVess Derek Wayne · Kempner, TXN1953YDavid Michael B · Miami Beach, FLN1954YSasse David L · Rio Rancho, NMN1955YBeckworth Willis S · Gonzales, LAN1957YGuedon Aviation LLC · Natchez, MSN1959YJam Aviation LLC · Wallace, MIN1960YWhite Duwayne F · Hermiston, ORN1961YWarnock Tony J · Mobile, ALN1962YRuther Jimmie M · Vacaville, CAN1963YLane Cary · Sapello, NMN1964YPerry Shawn M · Springfield, OHN1965YSvoboda Patrick J · Bucyrus, KSN1966YWeyhrich Dorothy · Windsor, CON1967FLeander Henry Anske IV · San Antonio, TX
Back to AD 75-09-08