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.
N681JBJuliet Bravo Aviation LLC · South Padre Island, TXN681LELeading Edge Aviation Inc · Bend, ORFirst renewal noticeN681LHChristiansen Aviation LLC · Wilmington, DEN681MAChristiansen Aviation LLC · Wilmington, DEN681TFAir Fleet Holdings LLC · Addison, TXN6820BAnderas Per R · Green Bay, WIN6820LFoode Frank J · Cordova, AKN6820NLopez George P · Sacramento, CAN6820VMwjf Air LLC · Barrington, NHN6821PComanche Logistics LLC · Lake City, FLN6821URed Baron LLC · Middletown, DEN6821VMiller Titan G · Tehachapi, CAN6822LDavis Robert E · Wasilla, AKN6822NBianchi Marion A · Goose Creek, SCN6822VDk Aero LLC · Greenville, SCN6822WAjf Enterprises LLC · Des Moines, IAN6823HClay Howard C II · San Francisco, CAN6823NTawil Anan · Salem, ORN6823PKoopmans Caleb · Bridgewater, SDN6823UClark Bradley K · Ypsilanti, MIN6823WThomas Kevin A · Selbyville, DEN6823YWingsleasing LLC · Wichita, KSN6824JMorrison Justin Gregory · Houston, TXN6824PAtlas Equipment LLC · Casper, WYN6824ULefevre Duane S · Grover, WYN6824WRoberts John R Jr · Homestead, FLN6825BAlborn Wyatt A · Homer, AKN6825JByrd Mark L · Belpre, OHN6825NWilliams Jerry Riley Sr · Wabbaseka, ARN6825URipley Holdings Ltd · Santa Monica, CAN6825VRegistered aircraftN6825YDenton J Frederick · Hutchinson Island, FLN6826NInterwest Management · Angwin, CAN6826WMartinak Charles J · Rehrersburg, PAN6827ULeong Thomas M · El Monte, CAN6827VAerostar Air LLC · Kilgore, TXN6827WShort Final Aviation LLC · Branson, MON6828BVantreese Jason B · Quanah, TXN6828JKdrd Holdings LLC · Texas City, TXN6828NFisher Scott · Searcy, ARN6828VEvanson Mark A · Wharton, TXN6828WOleary David L · Framingham, MAN6829NWilliams Mark J · Ojai, CAN6829VE N Entertainment Inc · El Dorado Hills, CAN682ABPiper Aircraft Inc · Vero Beach, FLN682ATTexas Flight Training Aircraft 8 LLC · Wilmington, DEN682FGlobal Flight Training Solutions Inc · Immokalee, FLN682JAYale Companies LLC DBA · Indianapolis, INN682LHChristiansen Aviation LLC · Wilmington, DEN682MAChristiansen Aviation LLC · Wilmington, DE
Back to AD 87-10-06 R1