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.
N8188MSmith Jeffrey E · Dunedin, FLN8188PPurdy Bryan T · Bryant, ARN8188TPiper Aircraft Inc · Vero Beach, FLN8188WBrewer Jordan L · Waynesboro, TNN8188YFly Anytime LLC · Kankakee, ILN81891Garnet Aviation LLC · Fort Worth, TXN81892Embry Kenneth · Nicholasville, KYN81894Yellow Dog Mgmt LLC · Fort Worth, TXN8189DWeese Chas K · Quinlan, TXN8189SAirplanes Unlimited LLC · Jackson, TNN8189WTri-City Mens Health LLC · Prescott, AZN818AHChandler Jerome P · Redondo Beach, CAN818ARLandsworth Corp · Monterey, CAN818BGMetz Joshua J · Peever, SDN818CCFlyit LLC · Camas, WAN818CPCivil Air Patrol · Maxwell Afb, ALN818DCCarr Donald A · Saratoga, CAN818DUPrescott John E Jr · Tempe, AZN818DVQuiroz Rene Joseph · Matthews, NCN818GRAngel Aviation LLC · Paradise, KSN818GSRegistered aircraftN818HEMaxwell James P · Rolling Prairie, INN818KDSunburst Aviation LLC · Fountain Hills, AZN818MJPika Design Inc · Spring Hill, KSN818RButler John · Hazelhurst, WIN818RDDomenico Ricky A · Westminster, CON818RVRegistered aircraftN818SKRummel John H · Prescott, AZN818SPN818xp LLC · Charleston, SCN818TAFoothill Aviation LLC · Iliamna, AKN818TECentral Airlines Inc · Leawood, KSN818VCMann John Franklin Jr · Manetta, GAN818VHAltitude Aviatin Services LLC · Mountain Home, IDN818VMReitz Brian C · Tehachapi, CAN818WCCrawford Beau W · Willow, AKN818WDWhiskey Bravo II LLC · Newton, KSN818WWMorrison Douglas K · North Branch, NJN818YInternational Air Services Inc Trustee · Carson City, NVN819Huseby Kelly E · Hulett, WYN8190DMagnuson Lucile · Mc Grath, AKN8190WA&M Aviation LLC · Tewksbury, MAN81916Rrg Software LLC · Alpine, CAN8191CLee Gerald R · Glennallen, AKN8191DSwede Aviation LLC · Tucson, AZN8191HPorter John W · Center, TXN8191PN8191p LLC · Snowflake, AZN8191VNelson Ronald R · Berthoud, CON8191XA&J Aircraft Leasing Inc · Burlington, CON81926Burkhardt David · Oregon City, ORN8192CD&K Aviation Inc · Milford, IA
Back to AD 87-10-06 R1