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.
N50020Pickering Michael A · Walpole, NHN50025Chapman Kyle W · Orange Beach, ALN50027Worthington Gary L · Swifton, ARN5002ABrown Richard J · Lexington, TNN50033Bulloch Scott W · Columbia Station, OHN50035Jepsen James H · Flandreau, SDN50037Registered aircraftN5003AOverton Tommy D Sr · Clinton, LAN50040Portco Aviation LLC · Bonham, TXN50042Burcham Austin · Dallas, TXN50044Huffine Kenneth A · Caswell Beach, NCN50049Whitcher Todd D · Grayling, MIN5004AMoore Kelly N · Anchorage, AKN50053Zehnder Michael W · Elk Grove, CAN500591w1 Aero LLC · Issaquah, WAN5005AWood Ryan H · Anchorage, AKN5005HVollertsen Steve · Kenai, AKN50064Graves Charles L · Joplin, MON5006ASmokovitz Joseph M · Tecumseh, MIN50079Schmitt Rudy · Brookshire, TXN5007AWallace Christopher S H · Cleburne, TXN50090Schumacher Pamela J · Beach City, OHN50097N50097 LLC · Tulsa, OKN5009AOgorek Peter J · Milwaukee, WIN500BBHinton Glynn E · Slidell, LAN500BKFriest Eric J · Menomonie, WIN500FMuseum Of Flight Foundation · Seattle, WAN500SUOhio State University · Columbus, OHN50100Best Bobby R · Goldsboro, NCN50106Walker Charles B · Angleton, TXN50108Gibbs Robert I · Ravenswood, WVN5010HThompson Trent A · Forsyth, MTN50110Coger Charles E · Huntsville, ARN50115Affordable Flight Time LLC · Eagle River, AKN50118Carver Alan H · Winder, GAN5011ABores Scott J · Huron, OHN50132Dunaire LLC · Mechanicsburg, PAN50133Pilot Legal Funding Inc · Fresh Meadows, NYN50138Kalb Brian A · Mechanicsburg, OHN5013AReed Ted R · San Angelo, TXN50140Air Devices Company LLC · Alpena, MIN50146Aero Sceince International LLC · Martinez, GAN5014HMercair Services Inc · Florahome, FLN50150Above All Aviation Inc · Santa Barbara, CAN50151Thums April M · Murfreesboro, TNN50155Haupricht Andy C · Sanford, NCN50156Humanic Thomas J · Columbus, OHN50160Morales-Escareno Rogelio · San Diego, CAN5016AMoore Wallace Frank · Mckinney, TXN50170Moroney Aviation LLC · Chugiak, AK
Back to AD 94-05-05 R1