AD 75-09-07
Registered aircraft · 617
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-07')
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-07')
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-07') 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-07') 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.
N5689LCalovini Christopher T · Gahanna, OHN5705LKing William C · Huntington Beach, CAN5717LChristian George D · Kingwood, TXN5718LMullins John D · Harriman, TNN5719LGodoy Air LLC · Venice, FLN5720LKh Aircraft LLC · Denton, MTN5721LBerggren Ryan J · Newton, NJN5722LGoebel Kenneth G · Sarasota, FLN5723LPearlman Fredric M · Southfield, MIN5738LRosche Henry III · Loveland, OHN5739LMcgll Phil · Huntsville, ALN5741LWienclaw David E · Boise, IDN5742LGjorvad Steven A · Punta Gorda, FLN5743LHead William J · Verona, KYN5751LWoodward Stephen · Fountain Hills, AZN5752LLamas Frank A · Brackettville, TXN5764LBanks Jeffery L · Pensacola, FLN5768LWilliams Charles J · Murfreesboro, TNN5774LHickman Robert D · Mobile, ALN5775LGulfstream Aerospace Corp · Savannah, GAN5776LCollins Timothy · Northfield, MNN5777LSessums David L · Seabrook, TXN5783LCarter Ryan L · Blackshear, GAN5785LVance Marc G · Canal Winchester, OHN5790LSeveca Ventures LLC DBA · Arcola, TXN5791LGuytek Aviation LLC · Margate, FLN5794LVanhorn Wyatt A · Macon, GAN5799LYoder George R · North Pole, AKN584YKBachman David A · Griggsville, ILN5901LDuff John R · Farmers Branch, TXN5902LWaffle Matthew · Bainbridge Island, WAN5904LRegistration Pending · Orem, UTRegistration pending, pending cancellationN5906LSonshine Unlimited LLC · Canfield, OHN5917LHill Jeffrey A · Boise, IDN5918LRobello Mel K · San Jose, CAFirst renewal noticeN5919LMckee Marty R · Lenoir City, TNN5920LSharratt Mark M · Ogilvie, MNN5922LJokerst Kenneth · Saint Louis, MON5927LTri State Airmotive LLC · Berryville, ARN5931LLuft Aviation Inc · Wilmington, DEN5938LMidland Avionics LLC · Louisville, KYN5942LSimulation International Management Inc · Tulsa, OKN5943LBlackmore Marc A · Hilltop Lakes, TXN5944LHoover Charles J · Logansport, INN5951LWilson Joe M · Lucedale, MSN5952LAskew Stell B III · Durham, NCN5953LTaylor John W Jr · Metairie, LAN5961LRobinson Morton · Fort Townsend, WAN5964LHortman Walter J · Ivyland, PAN5967LRegistration Pending · Carolina, PRRegistration pending
Back to AD 75-09-07