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.
N80810White Hawk Aviation Inc · Brandy Station, VAN80816Laurel Highlands Aeronautical Academy · Latrobe, PAN8081CBartlett Branden S · Eagle River, AKN8081DZwiacher John W · Green Lake, WIN8081GGonzalez Biorky · Atoka, TNN8081PCraner Andrew · Richfield, IDN8081YFerron Peter P Jr · Arlington, TNN80820Palmer Thomas T · Kapowsin, WAN80824Streamline Aviation LLC · Battlefield, MON80829Johnson Kyle A · Cheshire, CTN8082EAviation Access LLC · Van Nuys, CAN8082HWalters Glenn L · Triadelphia, WVN8082KWood Roger E · Waxhaw, NCN8082PSkyriders Inc · Albuquerque, NMN8082WWallace Louis Wayne · Sherman, TXN80830Mahnattan Flying Tigers Inc · Bozeman, MTN80834Odom Kirkland R Jr · Clayton, NCN80836Kirby Jerry N · Westmoreland, TNN80837Lucky Richard E · Skipperville, ALN80838Green Timothy R · Marblehead, MAN8083DRegistered aircraftN8083VMorris Allyn D · Woodinville, WAN8083WNedelea Traian · Katy, TXN8083YJuliet Deltaahh LLC · Vero Beach, FLN80841Sparta 140 Club Inc · Grand Rapids, MIN80842Augusta Aviation Inc · Augusta, GAN80847Evergreen Flying Club Inc · Medina, WAN8084NBlack Tie Limousine LLC · Springville, ALN8084PSmith Wayne R · Pittsford, NYN8084WFieldgrove Matt L · Somerton, AZN8084YFilippone Christopher A · Ormond Beach, FLFirst renewal noticeN80853Candace A Larned Enterprises Inc · Long Beach, CAN80855Bowe Joseph E DBA · Chippewa Falls, WIN8085ALane Community College · Eugene, ORN8085EMcdonald Douglas A · Falls Church, VAN8085WFireside Aviators Assn Corp · San Jose, CAFirst renewal noticeN8085XGorkes Richard E Jr · Lilburn, GAN8085YCoffey Aeronautical Services LLC · Knoxville, TNN80864Kessler Garry A · Lansing, WVN80865Green Rick A · Hudson, IAN80866Preston Richard K Trustee · Albuquerque, NMN80868Paradis Paul A · Bar Harbor, MEN8086DHinderberger Bryan J · Juneau, AKN8086ECoker Chadwick Daryl · Goldsboro, NCN8086GMason Aviation Club LLC · Mason, MIN8086HCloud Catcher Aviation LLC · Great Falls, MTN8086KClubs 2 LLC · Calabasas, CAN8086NDakota Group Inc · Rockaway, NJN80870Robben William J · Pampa, TXN80871Monnin Aviation LLC · Amherst, NY
Back to AD 87-10-06 R1