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.
N610UBoard Of Regents Of The University Of Oklahoma · Norman, OKN6110AState Of Montana · Helena, MTN6110CLueck Taylor W · Wasilla, AKN6110WZimmerman David A · Memphis, TNN6110XVitale Matthew W · Lithia Springs, GAN6111DAdventure Flight LLC · Duchesne, UTN6112JColeman Timothy Lynn · Port Charlotte, FLN6112PBurnett Jennifer · Palmer, AKN6112SHall Metal Corp · Fort Pierce, FLN6112WRoberts Jackie P · Bangs, TXN6113JOracle Aviation LLC · Omaha, NEN6113NKrabill Ronald D · Halsey, ORN6113RColorado Northwestern Community College · Rangely, CON6113VLegacy Lsa LLC · Plainview, TXN6113WMurray Brian C · Jonesboro, ARN6114NSabourin David R · Draper, UTN6114PCompton Mark E · Garfield, KYN6114SGoral William W · Redlands, CAN6114WGottschalk William R · Fort Atkinson, WIN6114XHardy Gareth R · Thatcher, AZN6114YFlies Warren E · Mesa, AZN6115DGeske Robert L · Enderlin, NDN6115SGan Specialties Inc · Pocatello, IDN61160Hat Creek Holding Company LLC · Bellville, TXN6116JGlobal Technical Services Inc · Fort Worth, TXN6116WKlyder Thomas A · Inverness, FLN6117PFriesen Aiden · Grants Pass, ORN6117WRoesler Robert D · Gordonsville, VAN6118DAtkinson James A · Bouse, AZN6118PNovak Mark S · Dawson, NEN6118WPiekielek John L · Punxsutawney, PAN6119DMeyer Robert M · Lancaster, NYN6119PModisette Jeremy W · Baldwin, GAN6119VN6119v LLC · Boca Raton, FLN611ADValiair Lc Trustee · Casper, WYN611ALMaverick Management Montana LLC · Yarmouth Port, MAN611APDobry Robert S · Crescent City, FLN611BDClement Aviation Inc · Tea, SDN611BRKnick Michael J · Camarillo, CAN611CAWilliams Todd A · Littleton, CON611DGMiller Stephen James · Shreveport, LAN611DMFildes Robert · Troy, MON611DPInversiones Flg Inc · Dorado, PRN611DWNav Solutions LLC · Lewes, DEN611DXRegistered aircraftN611EAEndeavour Flight Training Inc · Opa Locka, FLN611EVAero Activities LLC · Edgewood, NMN611FLZipp Nicole E · Raleigh, NCN611FTCoco Aircraft Inc · Merritt Island, FLN611HMPhysical Systems Inc · Carson City, NV
Back to AD 87-10-06 R1