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.
N88061Stoican Steve G · Ryegate, MTN88063Evenson Gabriel J · Fargo, NDN88065Obx Airplanes LLC · Manteo, NCN88066Nightingale Patrick R · Lakewood, CAN8806JLytle Hugh R · Senoia, GAN8806KMadsen Travis E · New Underwood, SDN8806LMadsen Travis E · New Underwood, SDN8806NHorne Terry A · Carefree, AZN8806PZiolkowski James E · Amarillo, TXN8806WKennemer Mark · San Angelo, TXN8807Potter David · Huntley, ILN88078Khm Investments Inc · Lehi, UTN8807DGorski Tim B · Larsen, WIN8807JNorris Dana G III · Zanesville, OHN8807NTruax James D · Roanoke, INN8807PRegistered aircraftN8807WSimon Randall V P · Fairbanks, AKN8807YRich Lucas Aircraft Sales LLC · Lincoln Park, NJN8807ZMadsen Travis E · New Underwood, SDN88081Butler Julie L · Los Osos, CAN88083N3542w Inc · Wilmington, DEN88085Poulson Daniel J · Anchorage, AKN8808BSemple Gary W · Flaxville, MTN8808DDwight Thomas W · Castalia, OHN8808JCoulliette Brian K · Jacksonville, FLN8808WHolysz Matthew M · Vicksburg, MIN8808YAukes Brian E · Huxley, IAN88092Verhulst Charles · Reva, SDN88098Merriwether David E · Whitesburg, GAN8809PPa24 LLC · Painesville, OHN8809UDoyles Ag Services LLC · Two Buttes, CON880CBJ-Airco LLC · Nashville, TNN880FTFlorida Institute Of Technology · Melbourne, FLN880GLNew England Airlines Inc · Westerly, RIN880HCBadger Heli Corp · Wilmington, DEN880JGGray Richard D · White Stone, VAN880MXCool Breeze LLC · Shelbyville, KYN880PUPurdue University Trustees · West Lafayette, INN880RCPuerto Rico Aircraft Leasing Corp · Ceiba, PRN880SCKc Hawgs Inc · Wilmington, DEN880THAviation Peter Corp Of New York · New York, NYN880XPAllen Ryan L · Lafayette, INN88108Nor-Wes Inc · Shreveport, LAN8810DNorman Timothy J · Tofte, MNN8810NShawl Robert M · Woodlake, CAN8810WLayne Andrew P · North Port, FLN88110Lovas Thomas A · Anchorage, AKN88118Richard Thomas W · Greenville, MSN88119Aysta Nathan P · Hermantown, MNN8811UAlder William D III · Athens, OH
Back to AD 87-10-06 R1