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.
N669AKRegistered aircraftN669CEOne Pft LLC · Denton, MTN669CRIrizarry Betsy M · Mayaguez, PRN669CWPrecision Air Inc · Nelson Lagoon, AKN669DKBrunner Matthew W · Bellingham, WAN669GBBernardi Gary R · New Cumberland, PAN669JCloud Splitter Inc · Columbia, CAN669KPClink Andrew D · Phoenix, AZN669PBluhm Daniel A · Gold Hill, ORN669RVN669rv LLC · New Albany, INN669RWRhodes Brian W · Valdez, AKN669SHulick Kent · Houston, TXN669SMClearance Clarence Aviation LLC · Hallsville, TXN669SNKajans Douglas L · Reno, NVN669TJBouyea John M · Hillsboro, ORN669TMDirty Bird Helicopters LLC · Boerne, TXN669UShartle Austin W · Fredericksburg, PAN669WBBailey Donnie W Jr · Tyronza, ARN66AALift Aviation LLC · Kingston, MAN66AEAndreassi LLC · Bluffton, SCN66AJPalmer Paul H · Minden, LAN66AKDomke Daniel C · Fairbanks, AKN66ALXin Han Aviation LLC · Atwater, CAN66APPeterson Alex A · Ottertail, MNN66ATDeer Elm Aviation LLC · Owens Cross Roads, ALN66AUSky West Aviation Inc Trustee · Albuquerque, NMN66AWSg Aviation Inc · Clearwater, FLN66BHLj Air LLC · Ada, MIN66BRPierce Stephan L · Graham, TXN66CDKcsi Aerial Patrol Inc · Bakersfield, CAN66CGPosada Raul Ignacion · El Paso, TXN66CMMadson Jerome R · Goodyear, AZN66CRRazer Chester R · Columbia, ILN66DLIzzard William S · Crescent City, FLN66DSPaulsen Rebecca D · Broken Arrow, OKN66EMichaud Michael A · Winslow, MEN66EBAj Aviation Services LLC · Midland, TXN66EGWashburn Tom · Terrell, TXN66FBJames W Woodward · Sagle, IDN66FDExtra Air LLC · Port Orange, FLN66FRBledsoe James C · Hugo, CON66FUGreen Steven D · Underhill, VTN66FWBracilano Robert A · Virginia Beach, VAN66GCBecker Air LLC · Grand Rapids, MIN66GJShamrock Aviation LLC · Seabrook, NHN66GNMoye Brian C · Naples, FLN66GVPearson Robert L IV · Spartanburg, SCN66GZGarabedian John H · Southborough, MAN66HERausch William Donald · Ontario, NYN66HUUzzle Harry L · San Antonio, TX
Back to AD 87-10-06 R1