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.
N808WDJones Colby C · Honolulu, HIN808WTSchool Board Of Leon County Florida · Tallahassee, FLN808ZStephens William C · Wilmington, NCN808ZTDepartment Of Homeland Security · Washington, DCN80903Southern Aircraft Consultancy Inc Trustee · Casper, WYN80906Red Door Aviation LLC · Dover, DEN80908International Air Services Inc Trustee · Carson City, NVN80909Kirkman Todd · Port Charlotte, FLN8090ELeslie H Mcelhany DBA · Watertown, SDN8090FDouglas Malik · Mcdonough, GAN8090JWesellairplanes.Com Inc · Wilmington, DEN8090LWilliams Chris B · Reno, NVN8090TN8090t LLC · Austin, TXN8090YFlyin Gators LLC · New Smyrna Beach, FLN80912Bay Area Concrete LLC · Hayward, CAN80914Cp Aviation Inc · Santa Paula, CAN8091DJohnston Zach H · Soldotna, AKN8091EChristiansen Aviation LLC · Wilmington, DEN8091PWaggoner Robert A · Decatur, TXN8091RParis Air Inc · Vero Beach, FLN8091WClement Timothy S · Skidmore, MON8091XBlack Hunter F · Blanding, UTN8091YStevens Charles R · Williamsburg, MIN80921Conerly Group LLC · Denham Springs, LAN80926Flight Leasing Corp · Wilmington, DEN80928Bellingham Aviation Services LLC · Bellingham, WAN8092ERaleigh Flying Club LLC · Chapel Hill, NCN8092GEarly Stephen · Sharpsburg, GAN8092HUnited States Air Force Owner · Hanscom Afb, MAN8092NCash Management Consulting LLC · Granite Springs, NYN8092WDidea Aviation LLC · Orlando, FLN8092YStoks Gary R · Canby, MNN80931Augusta Aviation Inc · Augusta, GAN80934Cogelia Joseph M · Winchester, VAN80939Levin Joseph · Yukon, OKN8093DSmith Ihler M · Fairbanks, AKN8093GFargo Jet Center LLC · Fargo, NDN8093HSarraf Majid · Aliso Viejo, CAN8093NSaraland High School · Saraland, ALN8093PFly Boyz LLC · Black Hawk, SDN80941Holombo Ray J · Taylors, SCN8094AMuhlenberg Barry Vk · Pottstown, PAN8094CPowell David J · Endicott, NYN8094DHigh Exposure Inc · Wilmington, DEN8094NEggan Mark A · Lee Center, NYN8094QSpitzer Helicopter LLC · Woodland Hills, CAN8094RDoll William J · Carlisle, PAN8094VJeppesen LLC · Champlin, MNN8094WMatney Tara · Abingdon, VAN8094YJamshidi Kourush · Kalamazoo, MI
Back to AD 87-10-06 R1