AD 75-16-10
Registered aircraft · 2,695
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-16-10')
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-16-10')
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-16-10') 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-16-10') 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.
N142MCCassen Mark E · Wilson, WYN142SMed Care Inc · Grand Island, NEN142TWInternational Air Services Inc Trustee · Carson City, NVN1440R39a LLC · Sioux Falls, SDN1449GFayettenam Aero LLC · Laurinburg, NCN144RCKilgore Shawn K · Argyle, TXN1451GCox Keith L · Griffin, GAN145DDemaray Russell N · Sedona, AZN145XBaron 55 LLC · Hutchinson, MNN146CPlanes & Parts Inc · Weston, FLN147GGZeng Robert E · Owasso, OKN148DSEast Ramp Aviation LLC · Baton Rouge, LAN14AJChalk 2 Inc · Apple Valley, CAN14CEFacility Concepts Developments LLC · Jackson, MSN14DADonaire Aviation LLC · Tampa, FLN14JHRegistered aircraftN14XMMedical Diagnostic Imaging Inc · Sacramento, CAN1500LLandolt Gregg E · Moreno Valley, CAN1509ZHeinrich John W · Chandler, AZN1511WFlorida Float Plane LLC · Coral Gables, FLN1515WCenturionair LLC · Greenville, SCN151FClark Robert G · Healdsburg, CAN1524ZColumbus Baron Partners Llp · Columbus, GAN1526MGarmin At Inc · Salem, ORN1526WSmith Neil Walter · Rincon, GAN1529SRich Aviation Services LLC · Fort Worth, TXN152BGBlossman Gas Of North Carolina Inc · Swannanoa, NCN1531ZShenandoah Whalen · Amelia, OHN1545WM T Air LLC · Olive Branch, MSN1545ZMcpherson Russell H · Forest Lake, MNN154QBrandon Sidney Jordan III · Dundas, VAN1552WT3 Aerosports LLC · Vian, OKN1557W557 Whiskey LLC · Superior, WIN155AGPlane Fun Inc Tr Trustee · Snellville, GAN155FRSpeed Aviation Holdings LLC · Lewes, DEN155JAStavrides Paul · Hartsville, PAN155JB2mec Holdings LLC · Kalispell, MTN155LUnderwood Robert · Waxahachie, TXN155LCAle & Quail Club LLC · Cheyenne, WYN155STAzimi Shahram · Hayward, CAN155WCTca Equities LLC · Advance, NCN1560YPacific Integrated Handling · Tacoma, WAN1561WEmpresas Marex Inc · Mayaguez, PRN1564LWhipple Cory · Senatobia, MSN1564SRegistered aircraftN1566KShaw David C · Santa Barbara, CAN1566W66 Whiskey LLC · Atlanta, GAN1567AKarsten Steven R · San Juan Capo, CAN1567NAuburn Simflight LLC · Auburn, ALN15688Moses & Associates Inc · Gainesville, FL
Back to AD 75-16-10