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.
N7029WUSA Aircraft Leasing LLC · Dover, DEN702AWBrown Pryce R · Anchorage, AKN702BSTwo Bravo Sierra LLC · Auburn, CAN702DBShiffer David A · Woodstock, OHN702DCTaylor Denise DBA · Lincoln, CAN702GTsiouklas Aviation Inc · Dunedin, FLN702GRAir America Flight Center LLC · Daytona Beach, FLN702JWisdom Murrel Wade · Nashville, ARN702RASmtm Holdings Inc · Wilmington, DEN702RVWhipple Bruce F · Rockford, MIN702TKWells Lance L · Hanksville, UTN702XLeonard Steven E · Wichita, KSN7030PMartens And Wyatt Air Service LLC · North Platte, NEN7030RAlpha Kilo Aviation LLC · Wasilla, AKN7031ASmith Helicopters Inc · Cotulla, TXN7031BMason Crosby H · Zebulon, NCN7031CWestern New York Flying Club Inc · Bowmansville, NYN7031WEarl Hittle Aero Inc · Greenville, OHN70323Sky Equity LLC · Woodbury, MNN7032BNetherby Richard J · Wake Forest, NCN7032MProbst John D · Del Norte, CON7032WFleming William P · Tomah, WIN7032YBoonedocks LLC · Valley, ALN7032ZJones James William III · Lebanon, VAN7033FNaugler Winsor III · Fort Washington, PAN7033WRegistered aircraftN-number assigned, not yet registeredN70340Wings Over Texas Holdings LLC · Denton, TXN7034GFat Tyre Flyers LLC · Moses Lake, WAN7034KMorrison Robert H · Fort Denaud, FLN7034QTesch David P · Pardeeville, WIN7034RMacallen Chemical Inc · Monroe, LAN7034WCooke Riley O · Bridger, MTN7035DWall Quinton · Clearfield, UTN7035GWilkening Owen A · Gardena, CAN7035KZangs William J · Poplar Grove, ILN7035QEarly Bird Aviation LLC · Phoenix, AZN7035WJerome Jeffrey A · Conneaut Lake, PAN7036Mcdonald Kenneth G · Vancouver, WAN7036DLoch Paul M · Miramar, FLN7036FLa Vigne Henry A · Hercules, CAN7036PPumphrey Vickie E · Devine, TXN7036WArizona Flying Pigs LLC · Flagstaff, AZN70376Sawyer Gregory T · Olga, WAN70378Vertol Systems Company Inc · Destin, FLN7037DRegistration Pending · Eagle River, AKRegistration pendingN7037GN7037g Inc · Newark, DEN7037QJohnson Joe N · Smithville, TNN7037RJames Jerome A · Sioux Falls, SDN70380Mindy Ltd LLC · Muscatine, IAN70386Johnson Ben A · Gainesboro, TN
Back to AD 90-04-06 R1