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.
N7173WCastro Joaquin H · Wellington, FLN7174BMercil Richard · Grand Forks, NDN7174GMaloney John T · Deer Park, NYN7174KBracarelli Lisa A · Big Lake, AKN7174UVondross James B · Portland, ORN7174VEast Carolina Aviation LLC · Camden, NCN7175GMontgomery Monty · Cave Spring, GAN7175KTaildragger Aero LLC · Saint John, WAN7175LDelong Aviation Services LLC · Murray, UTN7175RElks Virginia L · Chocowinity, NCN7175UWagner Mark · Grass Valley, CAN7176ASwierk Joshua J · Valdez, AKN7176BRegistered aircraftN7176QJax Beach Aviation LLC · Jacksonville, FLN7176VZammit Joseph A · Riverside, CAN7177DMurphy Brandon M · Edinburg, PAN7177GCoats George A · The Woodlands, TXN7177LSale Reported · Punta Gorda, FLSale reportedN7177QLeonard William K · Seattle, WAN7177RSandifer Darian A · Speedwell, TNN7178KPavlus Igor V · Wasilla, AKN7178LRi Flying Club Inc · Fullerton, CAN7178MCiolkosz Ryan · Anchorage, AKN7178QSkylens LLC · Hammond, LAN7178UBell Construction Inc · Napa, CAN7178VUhl Jack G · Bloomington, MNN7178WSnyder Michael P Jr · Reno, NVN7179BBue B G · Palmer, AKN7179DLeggett Bryce L · Eola, TXN7179RIfly Aviation LLC · Ephrata, PAN7179WSummit Concepts LLC · Five Points, ALN717ACKcd Aviation LLC · Tonica, ILN717ARJones Joshua W · Hudson, MAN717BMMitchell Matthew S · Timnath, CON717BSTla Inc · Middletown, DEN717BYWhite Kenneth · Rancho Cordova, CAN717CAScott Henry Bach · Yakima, WAN717CEHuffman Jacob M III · Burleson, TXN717DBJohnston David M · Elwood, INN717FLNorth Texas Aeronautics LLC · Burleson, TXN717FTMurtha Ronald A Jr · Sycamore, ILN717HCLeading Edge Leasing LLC · Wilmington, DEN717HQArwen Evenstar LLC · Wilmington, DEN717JDKerr Ryan R · Mora, MNN717LVPage Wayne N · Corning, IAN717MXBailey Steven W · Puyallup, WAN717NARegistered aircraftN717PRRensink Paul S · Battle Ground, WAN717RFWings Flight Enterprises Inc · Danville, KYN717RLDouble Rainbow Aviation LLC · North Fort Myers, FL
Back to AD 90-04-06 R1