AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-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:90-04-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:90-04-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:90-04-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.
N80816Laurel Highlands Aeronautical Academy · Latrobe, PAN8081CBartlett Branden S · Eagle River, AKN8081DZwiacher John W · Green Lake, WIN8081GGonzalez Biorky · Atoka, TNN8081HThornton J T · Dora, MON8081PCraner Andrew · Richfield, IDN8081UEllett Cathy M · Ferriday, LAN8081YFerron Peter P Jr · Arlington, TNN80820Palmer Thomas T · Kapowsin, WAN80824Streamline Aviation LLC · Battlefield, MON80829Johnson Kyle A · Cheshire, CTN8082CGilbert Ray E · Buffalo, SDN8082EAviation Access LLC · Van Nuys, CAN8082HWalters Glenn L · Triadelphia, WVN8082KWood Roger E · Waxhaw, NCN8082WWallace Louis Wayne · Sherman, TXN80830Mahnattan Flying Tigers Inc · Bozeman, MTN80836Kirby Jerry N · Westmoreland, TNN80837Lucky Richard E · Skipperville, ALN8083DRegistered aircraftN8083WNedelea Traian · Katy, TXN80841Sparta 140 Club Inc · Grand Rapids, MIN80842Augusta Aviation Inc · Augusta, GAN80847Evergreen Flying Club Inc · Medina, WAN8084BN8084b LLC · Fort Worth, TXN8084NBlack 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, WIN80856Andrews Terry L · Camp Verde, AZN8085ALane 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, MEN8086CRoeloffs Arie · Wendell, IDN8086DHinderberger Bryan J · Juneau, AKN8086ECoker Chadwick Daryl · Goldsboro, NCN8086GMason Aviation Club LLC · Mason, MIN8086HCloud Catcher Aviation LLC · Great Falls, MTN8086KClubs 2 LLC · Calabasas, CAN80870Robben William J · Pampa, TXN80871Monnin Aviation LLC · Amherst, NYN80872Yakima 872 Flying Club · Yakima, WA
Back to AD 90-04-06 R1