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.
N7643GTriad Aviation Academy LLC · Greensboro, NCN7643WBlasen Matthew C · La Center, WAN7644DBeale David K · Tullahoma, TNN7644FBel Holdings LLC · Albert Lea, MNN7644GSkypark Inc · Wadsworth, OHN7644PWhobrey Andrew · Bee Spring, KYN7644WCatania Robert S · Mooresville, INN7645FSagittarius Fox Aviation LLC · San Francisco, CAN7645JArrow 8 LLC · Chicago, ILN7645WGold Rush Air LLC · Anchorage, AKN7645YN7645y LLC · Sheridan, WYN7646DBaier Warren R · Horicon, WIN7646FShouling & Philip Enterprise · Lancaster, CAN7646GSky Aviation LLC · Encinitas, CAN7646JRavotti Air LLC · Leechburg, PAN7646PWebster Michael Sean · Hubert, NCN7647GIowa Lakes Community College · Estherville, IAN7647KLee Andrew · Anchorage, AKN7647PEhni Scott Michael · Trinity, TXN7647WBeaulaurier Robert N · Walla Walla, WAN7648RJohnson Jerome L · Victorville, CAN7648VMiller Jerold R · Deering, NDN7648YFingerlakes Wing And Rotor LLC · Seneca Falls, NYN7649PBurton David P · Harviell, MON7649VBoeing Co · Renton, WAN7649WPatterson Cameron L · Stafford, VAN764AAWings Over Texas Holdings LLC · Denton, TXN764BKFairmont State University · Fairmont, WVN764CCYale Companies LLC DBA Hot Wings Aviation LLC · Fishers, INN764JBLance Aviation Inc · Lakeland, FLN764NDUniversity Of North Dakota · Grand Forks, NDN765Moby Partnership · Albuquerque, NMN7650JAmsg Transport LLC · Southfield, MIN7650SMoore Aviation LLC · Westminster, CON7650VNorth Carolina Soaring Association · Zebulon, NCN7651DLehrman Ronald L · Brownsburg, INN7651FAishvaryam LLC DBA · Lancaster, TXN7651HGosbrook Aviation LLC · Lewes, DEN7651PShisler William · Phoenix, AZN7652FProfessional Aviation Aircraft Services Ltd · New Philadelphia, OHN7652JCamilo Rafael Gonzalez Moya · Fort Worth, TXN7652POso Air LLC · Missoula, MTN7652WCarlson Justin Q · Sheridan, WYN7652YMetro West Ambulance · Hillsboro, ORN7653FHyldburg Aviation Inc · Plymouth, MAN7653JGulley Peter M · Karnes City, TXN7653PThomason Tony L · Williamson, GAN7653RBeech Aviators Of Houston LLC · Kingsland, TXN7653STow Plane Idaho LLC · Boise, IDN7653WHernandez Kelvin · Wilkes Barre, PA
Back to AD 87-10-06 R1