AD 75-01-07
Registered aircraft · 2,118
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-01-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-01-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-01-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-01-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.
N35YRTonini Farm And Cattle Co · San Luis Obispo, CAN360TThroop Greg J · Spokane, WAN3627AHint Mart H · Peachtree City, GAN3629ADarrow Mark A Trustee · Mukilteo, WAN362TBarnett Blake C · Boynton Beach, FLN3632APauly Adam · Macomb, MIN36363Klein John · Woodland, CAN363BCBig Cha Inc · Wilmington, DEN3650AMcclain Aviation LLC · Newark, DEN3676YYesco Administration LLC · Salt Lake City, UTN3692ABva Bonanza LLC · Keizer, ORN3693AC And F Enterprise L L C · Milford, MIN36MZWestfall Thadd W · Three Lakes, WIN3702QBonander Jeremy Ray · Tucson, AZN3704QRipley Robert G · Griffin, GAN3705QCourts Data Center Consulting LLC · Lakeway, TXN3706QSteed George W III · Silverdale, WAN3707QTroutman Shaun · Johnson, KSN3713QAirborne Adventures LLC · Clive, IAN3715QShellington Justin R · Columbus, NJN3720QM M & O Aviation Inc · Northglenn, CON3728AAc Bonanza LLC · Carrollton, TXN3731QMoore J D · Lawson, MON3735BBas Part Sales LLC · Greeley, CON3748QThoendel Jason · Saint Charles, MON374TOtt James D · Kilgore, TXN3753QMintz Jason · Houston, TXN3759QJ & C Companies LLC · Mesa, AZN3762QHarris Randal Glenn · Sedona, AZN3763QOrr Robert · San Clemente, CAN3770QTaylor Zachary S · Shawnee, OKN3772QBoav8r LLC · Marana, AZN3781QWelch Michael R · Roanoke, TXN3785QGo Fly Missoula LLC · Missoula, MTN3788QSale Reported · Oklahoma City, OKSale reported, canceledN3789QHercules Jesse T · Memphis, TNN378JRay Preston C · Chula Vista, CAN3793QMartin Tully T · Idalou, TXN3797QKolb Norman R · Tijeras, NMN3798QMartin-Fosters Fuel Service Inc · Seminole, OKN3799QDtb Aviation Inc · Los Gatos, CAN37KBMccraw Michael · Myakka City, FLN37MKSkyhoundmedia Inc · Royal Oak, MIN3803MRegistered aircraftN38065Boyd David · Havasu, AZN3822URegistration Pending · Stillwater, MNRegistration pendingN3847XCrowder Jonathan Slade · Columbus, INN3868URegistered aircraftN388BCAerospace Trust Management LLC · Wilmington, DEN389MCCarstetter Melvin D · Lakebay, WA
Back to AD 75-01-07