AD 94-05-05 R1
Registered aircraft · 26,232
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.
N570SRRothstein Steven R · Punta Gorda, FLN570UABohl Howard M · Temecula, CAN5710RMarshall Fred R · Tulsa, OKN5710TLaney Charles A · Maiden, NCN5711CBrian Murray J · Pekin, ILN5711EHalbert Andrew D · Graham, WAN5711TColeman Darryl W · Fayetteville, GAN5712CFenton Jonathan B · Oregon City, ORN5712RGlobal Learning Solutions Inc · Montrose, CON5712TSessoms Keith V · Seagrove, NCN5713CWheaton Laramie · Iola, TXN5713RAirspeed Marketing LLC · Phoenix, AZN5713TSears Irwin C · Rockwall, TXN5714AWeddle William H · Winston, NMN5715ASkinner Norman D · Osceola, IAN5715EStephany Peter · Umatilla, FLN5715TCarter James · Thornville, OHN5716ASaile Daniel K · Skiatook, OKN5716RUdenburg Scott M · Cotter, ARN5718GSwietek Robert E · Grand Rapids, MIN5718NJelinek Lynden · Montgomery, MNN5719APinson Danny L · Grand Junction, CON5719RProfessional Aviation Aircraft Services Ltd · New Philadelphia, OHN5720CWienk Cody · Bellevue, NEN5720TFrost Nathan L · Olympia, WAN5721TSeattle Seaplanes LLC · Seattle, WAN5722CNeumann John F · Walden, NYN5722EWinfrey Walter A Trustee · Auburn, CAN5722GSchmitt Rudy · Bulverde, TXN5722RCalhoun Barry R · Richardson, TXN5723AAdamson Steven C · Jonesboro, GAN5723CMid Pacific Aero Services LLC · Wahiawa, HIN5723RCoffey Bryan K · Anchorage, AKN5723TColeman David R · Limerick, MEN5724CRegistered aircraftN5724EGroup 59 LLC · Oro Valley, AZN5724GCrnic John F · Kirksville, MON5724RMartindale Bryan T · Springfield, ILN5726CPurcell Kim L · Placerville, CAN5726THall Edward M · Brainerd, MNN5727RBiederman Scott · Pompano Beach, FLN5728AMcgiffen Christine L · Vincennes, INN5728EThibodeau Thomas J · Honea Path, SCN5729AThomas Scott S · Wytheville, VAN5729ERhoades James W · Little Falls, MNN5729RMarreno Eddie J · Green Cove Springs, FLN5729TConservair Inc · Montgomery, TXN5730AMunson Steven L · Martinsburg, WVN5731CSmith Michael E · Willits, CAN5731RGoward Steven Lee · Oakley, MI
Back to AD 94-05-05 R1