AD 94-05-05 R1
Registered aircraft · 26,231
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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.
N2442JOlson Lanny R · Huron, SDN2442KSpirit Aviation N231az LLC · Austin, TXN2442LPratt Mark R · La Grande, ORN2442NBecker Anthony D · Northfield, MNN2443BBartholomew Don · Gardnerville, NVN2443DWeber Blake N · Sisters, ORN2443LOdlozil Henry W · Ennis, TXN2443NHayward Jeffrey L · Thomasville, GAN2443UIntream Companies LLC · Perryville, MON2444BRubiano Anthony · Cheyenne, WYN2444DBennett James E · Fredericksburg, TXN2444YConrad Matthew J · Dardenne Prairie, MON2445UPeachey Jason J · Milroy, PAN2445YNew England Aircraft Detailing LLC · Webster, MAN24466Clausen John R · San Antonio, TXN2446BHolliday Mark E · Lake Elmo, MNN2446DGreen Griffin LLC · Powell, OHN2446YMcmickle Edward R · Riverside, CAN2447UMccauley Stephen M · Buckley, WAN2447VCarpe Diem Atb LLC · Northfield, MNN2447YNeu Aviation LLC · Benton, LAN24485Overseas Flyway LLC · Tavernier, FLN2448DDrake Dwayne D · Fairbanks, AKN2448YTennison William T · Osprey, FLN2449BHolliday Mark E · Lake Elmo, MNN2449DEdwards Samuel W · Shady Shores, TXN2449KBlack Charles Bernard · Lenoir, NCN2449LSteier Tim · Salome, AZN2449NHoffman Stephen J · Seabrook, TXN2449UCurl Eric A · Olympia, WAN2449VTenhoff Lee L · Homer, AKN2450EWalton Camaron · Sherwood, ARN2450KBlue Cloud Aviation LLC · Turlock, CAN2450LRobinson Brandon J · Winona Lake, INN2450VAbbott Cedric M · Buckfield, MEN2451BSimply Living LLC · Fort Myers, FLFirst renewal noticeN2451LSky K Inc · Wilmington, DEN24520Mcfetridge Anne S Trustee · Fabius, NYN24523Royal David T · Duluth, MNN2452KCottonwood Flying Club · Rockford, ILN2453BWalker Ray · Sanger, TXN2453KWalden Taylor G · Pueblo, CON2453YNoteboom-Hegg LLC · Sioux Falls, SDN24549Vand Flyre Klub · Newfolden, MNN2454LFulbright Steven R · Prineville, ORN2454QTracemont Flyers LLC · Boyce, LAN2455DBurton Douglas M · Chehalis, WAN2455KBrice Beni H · Severna Park, MDN2455NMorse David W · Priest Lake, IDN2455YAircrafters French Valley Inc · Winchester, CA
Back to AD 94-05-05 R1