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.
N9502MStorer Daniel A · Guthrie, OKN9502WHellevang Ryan K · Duvall, WAN9503DHardison Allan · Castle Rock, CON9503MCurell Kenneth E · Centerville, OHN9503PClark Chris E · Sandy, UTN9503QGulf Coast Helicopters Inc · Pearland, TXN9503UAom Aircraft LLC · Wilmington, DEN9503WLoya Armando · Whittier, CAN9503YRoss Carl D · Arbuckle, CAN95044Mach Point Two Aviation LLC · Conroe, TXN9504DWilliams Jimmy Z · Sherman, TXN9504FRons Air Service Inc · Two Buttes, CON9504HPatterson Clifford Wayne · Murphy, TXN9504LTaylor William C · Portsmouth, NHN9504MNawratil Nicholas · Richmond, TXN9504WS&J Aviation LLC · Burlington, WAN95053Jamesweathers Robi J · Blaine, MNN9505DJutzi Curtis E · Ridgefield, WAN9505EKelso Ted M · Fort Worth, TXN9505HFinal Approach Aviation LLC · Danville, CAN9505JConnors Paul J II · Murrieta, CAN9505LClark Gabrial Scott · Humble, TXN9505MLeahy Michael P · Downers Grove, ILN9505PAlways Direct Airways LLC · Indian Trail, NCN95063Dugan Jason · Wellington, TXN95069Tower Aviation Of Reading Inc · Reading, PAN9506JEspinal Branhder · Union, NJN9506PMcclain Dean L · Torrington, WYN9506WAttitude Aviation Inc · Livermore, CAN95071Lund Jonathan J · Glencoe, MNN9507DKimball Raymond E · North Bend, ORN9507LBatra Sanjeev · Roseville, CAN9507MSanford Russell G · Brooks, GAN9507PW K Aviation LLC · Buffalo, SDN95080Johnson Patrick W · Toney, ALN95084Lyons Nathaniel R · Fort Scott, KSN95089Moll Michael J II · Mechanicville, NYN9508BRegistered aircraftN9508DLewis Stephen A III · Fleming, GAN9508JGandas Aero Inc · Eagan, MNN9509DMorrison Jim · Grandview, TXN9509JStevens Sheldon D · Clark, SDN950ACRed Carpet Aviation LLC · Carlsbad, CAN950DRRjc Skyhawk LLC · Middletown, DEN950DSSchmitt Douglas F · Bloomsbury, NJN950HPKansas Highway Patrol · Topeka, KSN950MEN950me LLC · Manassas, VAN950MMAngelo Gary P · Jonesboro, ARN950TBWeiss Elliott · Fresno, TXN950TECrutchfield Randolph E · Scottsdale, AZ
Back to AD 87-10-06 R1