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.
N3684KMeeks Michael D · Marion, TXN3684VHollywood Biplane LLC · Atlanta, GAN3685JBranson David F · Tucson, AZN3685LBarber Richard S · Baker, NVN3685SGarrison Randy L · Queen City, TXN3685THarvath John A Jr · Anchorage, AKN3686JSeasun Aviation LLC · Miami, FLN3686SBurg David J · Oroville, CAN3687JPacific Northwest Aeronautics Inc · Lewes, DENon-citizen corporation, flight hours not reportedN3688EEaa Chapter 540 Lancaster County · Smoketown, PAN3688LNamassivaya Nagaraju · Rexford, NYN3689ERegistration Pending · Mechanicsville, VARegistration pendingN3689HO Handley Hugh Jr · Rogersville, TNN3689JInnovative Restoration Aviation LLC · Slidell, LAN3689TVon Brock David C · Gulf Breeze, FLN3689VChvatal Daniel A · Jordan, MNN368ABStryker Kevin · Ben Wheeler, TXN368SCHannah Charles B · Skiatook, OKN3690ELowe David M · Sacramento, KYN3690LSmith Steve J · Magnolia, TXN3690TDunlap Gary P · Seattle, WAN3690VSather Evan A · Hayward, CAN36917Campbell Jeffrey W · Millinocket, MEN3691JS & S Aircraft LLC · Rathdrum, IDN3691SBogan Jeremy · Rusk, TXN3692SBrown Wesley B · Sparks, NVN3692TPitts Lynn L · Webb City, MON3693KTroyer Thomas A · Chickamauga, GAN3693SChianese Anthony · Wylie, TXN3693VLennox Gregory P · Encinitas, CAN3694SJstream Lc · Sheridan, WYN3694TSchock Niklas A · Palmer, AKN3694VBuzzard Air Service LLC · Carleton, MIN3695SZavada Michael S · Morris, MNN3696TRegistered aircraftN3696VMojica William E · Hilliard, OHN3697HFuller Randy M · Mooresville, NCN3697LShearair LLC · Valparaiso, INN3697SRossi Michael · Big Pine, CAN3697TShannon Christopher Ray · Nome, AKFirst renewal noticeN3698EVossman John · New Waverly, TXN3698JWise Tammy B · Eden, NCN3698TMccormick Ken C · Indian, AKN3699JBlock Time Bandits LLC · Boise, IDN369BZBartholomew Don · Gardnerville, NVN369DHLarsen David E · Alcester, SDN369MSStrack Brian L · Peyton, CON36ECGarcia Raymond F · Gilroy, CAN36FBCertified Aeronautical Products LLC · Moody, TXN36FTSerrino Sam K · Boardman, OH
Back to AD 94-05-05 R1