AD 87-10-06 R1
Registered aircraft · 72,010
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:87-10-06-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1')
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:87-10-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1') 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.
N6DGTimperman Eugene L · Cincinnati, OHN6DJRice Johnny D · Rosharon, TXN6ECDraco Flight School Inc · Chino, CAN6EMHall Don L · Lakeland, FLN6ETSumner Gary · Knoxville, TNN6FDScud Air 6fd LLC · Morgan, UTN6FGSmith Timothy S · Kinston, NCN6FTBrotman Bruce · Morgantown, WVN6GCLett Robert W · Dallas, TXN6GELemons Christopher P · Dexter, MON6GQCutsforth Robert S · Bellingham, WAN6GTVanguard Squadron Inc · Tea, SDN6GYYoung Gregory · Spring, TXN6HBHorneman Auric · Oakland, CAN6HCFriedrich James · Bakersfield, CAN6HMHenning Nancy E · Hardinsburg, KYN6HNTalbott Philip A · Galena, OHN6HPState Of Ohio · Columbus, OHN6HTColorado By Air LLC · Salida, CON6HYGbh Aviation · Santa Monica, CAN6JPrewitt Scott S · King City, CAN6JJNemecek Larry · Canyon Lake, TXN6JXGallaher Graham William · Los Angeles, CAN6JZFaith Church Of Sherman · Sherman, TXN6KPPhillips Keith E · Port Orange, FLN6KTHawaii Pacific Aviation Inc · Kailua Kona, HIN6LAttinger Brian D · Mechanicsburg, PAN6LVEaton Raymond S · Plantation, FLN6MBSierra Whiskey Aircraft LLC · Oakland, CAN6MHPaquette Daniel J · Belleville, MIFirst renewal noticeN6MXHale Mitchell D · Palmer, AKN6NGAvalle Carlos A · Livermore, CAN6NHStephens Timothy D · Springfield, MON6NSWestern Flying Club Inc · Burlington, NCN6PFSoplanda Matthew J · Willow, AKN6PMGoode Max T · Mariposa, CAFirst renewal noticeN6PTStrange Jim · Tyler, TXN6PUMoreno Juan T · Stockbridge, GAN6QUHoward Timothy D · Port Orange, FLN6RRegistered aircraftN6RBBush Robert · Landisville, PAN6RESouthwest Lakes Experience LLC · Sawyer, MIN6RXG&M Aviation LLC · Kokomo, INN6RYTracy David B · West Haven, UTN6SBFranklin Gary · Willow Beach, AZN6SGCedar Ridge Aviation LLC · Knox City, TXN6SKKilpatrick L Shawn · Hartwell, GAN6SYKirkpatrick Andrew T · Corpus Christi, TXN6TAGarrard Walter E · Elbert, CON6TDCapouch Michael J · Medaryville, IN
Back to AD 87-10-06 R1