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.
N88092Verhulst Charles · Reva, SDN88098Merriwether David E · Whitesburg, GAN880CBJ-Airco LLC · Nashville, TNN880FWebfoot Aviation LLC · Chesterfield, MON880FTFlorida Institute Of Technology · Melbourne, FLN880HCBadger Heli Corp · Wilmington, DEN880JGGray Richard D · White Stone, VAN880MABrekken Chris · Prescott, WIN880MXCool Breeze LLC · Shelbyville, KYN880PUPurdue University Trustees · West Lafayette, INN880RVHamilton David S · Locust Grove, GAN880THAviation Peter Corp Of New York · New York, NYN8810CGroenwegen Bruce C · Snohomish, WAN8810DNorman Timothy J · Tofte, MNN8810NShawl Robert M · Woodlake, CAN88110Lovas Thomas A · Anchorage, AKN88118Richard Thomas W · Greenville, MSN88119Aysta Nathan P · Hermantown, MNN8811UAlder William D III · Athens, OHN8811YHutchinson Douglas E · Cle Elum, WAN8812DSowders Darwin G · Robinson, TXN8812YSpain Air LLC · Dadeville, ALN88130Harper Clayton E · Seabrook, TXN88134Morris William F B · Klamath Falls, ORN8813MMja Flight LLC · Justin, TXN8813NLangton Shane A · Boise, IDN88140Green Flying Machine LLC · Prior Lake, MNN88144Hitchens Steven · Conesville, OHN88149Cheshire Brad F · Flower Mound, TXN8814FBas Part Sales LLC · Greeley, CON8814JCarey H Dwain · Cheyenne, WYN8814NMarshall Lance A · Portland, ORN8814YTwin C 14y LLC · Cape Coral, FLN88156Wilcox Aerial Applications Inc · Tilden, NEN8815NJenkins Roger Clayton II · Plain Dealing, LAN8815YBauer Andrew J · Concord, NCN88161Jordan Jay S · Wasilla, AKN88165Becker Aaron S · Santa Cruz, CAN8816CNye Brian M · Independence, ORN8816JHuff Roger A · Johnstown, OHN88172Hughes Glenn D · Wrightsville Beach, NCN8817CSharon Ricky E · Roberta, GAN8817JMy Bird Is Bigger Than Yours LLC · Fort Myers, FLN8817YWiehl Thomas K III · Earlysville, VAN88181Oglesby Holdings LLC · Henrico, VAN88182Dachnowicz Peter A · Avon, CTN88184Delmolino Kevin R Sr · Walkersville, MDN88188Blair Keeley A · Erie, CON88189Ocean Aerial Ads Inc · Ocean City, MDN8818CHalligan Austin C · Sidney, NE
Back to AD 90-04-06 R1