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.
N6710UMonroe Flying Club Inc · Glen Carbon, ILN6710ZHeatwole Oren · Dayton, VAN6711Blue Heron Marine & Air LLC · Fredericksburg, TXN6711BJohnson Nathaniel D · Attalla, ALN6711GQuality Aviation Inc · Atlanta, GAN6711JFirecrest LLC · Holly Springs, MSN6711NHanna William R · Castle Rock, CON6711PPietroburgo Stephen M · Colville, WAN6711UUlassin Kyle B · Corvallis, ORN6711WBrinkman Michael R · Cleveland, TNN6711YAero Services Lc · Woods Cross, UTN6711ZWoolslayer Joseph Patrick · Tulsa, OKN67123Spencer Lane Inc · Lewes, DEN6712AMcginnis Air LLC · Rising Star, TXN6712JF & F Flying Service Inc · Springfield, VAN6712USchell Kerry A · Arvada, CON67135Aviators Next Door LLC · Newnan, GAN6713UHinds Casey L · Seattle, WAN6714LBrost Bryan L · Canistota, SDN6714NLawler Thomas W Jr · French Lick, INN6714WFriend Henry H · Hibbs, PAN6715DHargett David · San Juan, PRN6715HFortanas Michael J · Temecula, CAN6715NWomble Phillip A · Enid, MSN6715PFrancis Investment Corp · Tulsa, OKN6715SFlores Willie Torres II · Junction City, KSN6715XOleyar John A · Houston, TXN6715ZW5 Land Services LLC · Okeechobee, FLN67166Milano Matthew G · The Woodlands, TXN67168Mgm Aero Flight Inc · Jordan, MNN6716NAmyett Stanley B · Brady, TXN6716UPickworth Jonathan · Philadelphia, PAN6716WSan Diego Community College District · San Diego, CAN6716YGot Wings LLC · Woodbury, NYN6716ZNextgen Flight Academy Inc · Riverside, CAN6717EDenrow Limited Lc · Shawnee, OKN6717KFranco Enterprises LLC · Sioux City, IAN6717NGaskill David E · Toledo, WAN6717VPierschbacher Clifton A · Marysville, WAN6717WFieri Douglas J · La Verne, CAN6717ZSmith Stephen A · Erwinna, PAN67180French Chris E Jr · Concord, NCN6718JWandro Nicholas John · Norman, OKN6718NHoefly Christopher S · Belleview, FLN6718POmalley Wendy · Alameda, CAN6718TBhatia Anil · Round Rock, TXN6718UBerra Robert J · Burtonsville, MDN6718VHavelin Jeffrey I · Port Charlotte, FLN6718WMorris Mark · Floral City, FLN6718YN6718y Lk Aircraft Holdings LLC · Wheeling, IL
Back to AD 87-10-06 R1