AD 84-10-01 R1
Registered aircraft · 20,481
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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.
N6162RSmjd LLC · Penrose, CON6162VAir Ventures Hawaii LLC · Lihue, HIN6162ZHolloman Afb Aero Club · Holloman Afb, NMN61632Cost Garret Alan · Tulalip, WAN6163UMcevoy Steven T · Aniak, AKN6164B64 Bravo LLC · Oberlin, OHN61653Michel Daniel T · Sterling, AKN6165FMainely Lobsters · Gulf Breeze, FLN61662Huston Stephen M · Hollister, CAN6166UBb Aviation LLC · Prescott, AZN6167BEdwards Darrell R · Artesia, NMN6167CSnyder Larry G · Holland, NYN6167KDuncan Marianna G · Lufkin, TXN6167LEastern Cincinnati Aviation Inc · Batavia, OHN6168BSafety Source LLC · Kirkland, WAN6168NRegistered aircraftN6169BTjs Plane LLC · Renton, WAN6169FWatrud Joel Carl · Waskish, MNN616CPTextron Aviation Inc · Wichita, KSN616MCFletcher Flying LLC · Russellville, ARN616PJLarson Paul S · San Carlos, CAN616WERodriguez Norberto R · Inwood, NYN61705White Robert Tyler · Pleasanton, CAN6170BEnglish Stanley P · Anchorage, AKN6170FWilkins Raymond E · Osceola, IAN6170NGarmin210 LLC · Willard, MON6170RBrown Michael R · Huntsville, ALN6171FDohrenwend Mark G · Owensboro, KYN61728Henderson James Ross · Garden Prairie, ILN6173FLesondank Stephen M · Bellvue, CON6173QKinder Mark Edward · Bozeman, MTN6173RBeyer Livestock Auction LLC · Clovis, NMN6174BN6174b LLC · Nokomis, FLN61758Skywagon Aero LLC · Wilmington, DEN6175RElinoff Neal D · Telluride, CON6176BWitzel Colton J · Frenchglen, ORN6176RJulius Kaleb · Mesa, CON6177BThomas Harry F Jr · Panama City, FLN61781Ryan Good Aviation LLC · Sioux Falls, SDN61782Schroeder Rodger · Chugwater, WYN6178BSeven Eight Bravo LLC · Billings, MTN61792Turnbull Jason D · Wasilla, AKN61798Mayo Michael E · Boerne, TXN617RRed Baron LLC · Middletown, DEN617TWTango Whiskey Aviation LLC · Cody, WYN6180Plane Fun Inc Tr Trustee · Snellville, GAN6180BNewton Raymond C Jr · Heath, TXN6180NMargiotta Russell A Trustee · Woodside, CAN6181ZDittrich James G · Anchorage, AKN6182Olson Gary P · Lanesboro, MN
Back to AD 84-10-01 R1