AD 47-21-21
Registered aircraft · 126
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:47-21-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:47-21-21')
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:47-21-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:47-21-21') 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.
N6283KTraylor Robert B · Millersview, TXFirst renewal noticeN6286KKomko Randy M · Mckenna, WAN6288CSouthern Aircraft Consultancy Inc Trustee · Casper, WYN6294KHill Bruce J · Mc Alpin, FLN6295KWallitner Aviation And Restoration LLC · Bremerton, WAN6302KRandall Adam M · Au Sable Forks, NYN6317KCoutches Steven S · Cameron Park, CAN6323KKosir John · Chardon, OHN6325KHigh Road Time LLC · West Palm Beach, FLN6342KBjorlie Paul A · Pekin, NDN6356KMonarch M Miller · Ocala, FLN6373KWoodberry Robert A · Mineral, VAN6375KHonrud Josepth C · Cal Nev Ari, NVN6381KSpencer John S · Indian, AKN6386KSouthern Aircraft Consultancy Inc Trustee · Casper, WYN6428KBus Bee Nlg LLC · Sheridan, WYN6429KMau Timothy J · Gardendale, ALFirst renewal noticeN6432KDicecco Thomas III · Bear, DEN6440KChase 13 LLC · Wilmington, DEN6443KBucher Burton W · North Chicago, ILN6449KHutchinson Daniel S · Lakeview, ORN6460KWasik Richard C · Frankston, TXN6467KHicks Jacob W · Crozet, VAN6485KCoutches Steven S · Cameron Park, CAN6488KMccutcheon Frank Jr · Scottsboro, ALN6490KWasik Richard C · Frankston, TXN6501KBertuca Judy A · Glennallen, AKN6505KBohl Howard M · Temecula, CAN6511KGateway Air Center Inc · Merced, CAN6517KVan Vleet Raymond J · Naperville, ILN6518KPullman Michael A · Scottsdale, AZN6519KLarrabee Consulting Group LLC · Dayton, OHN6522KKaskel Super Service LLC · Evansville, INN6523KVfr Ltd · Wilmington, DEN6538KPockrus Pat B · Mineral Wells, TXN6568KSandy George T · Tehachapi, CAFirst renewal noticeN6588KWais Richard J · Leesburg, FLN6589KPoules Alexander · Hope Valley, RIN6590KJohnson Christopher J · Tacoma, WAN6615KReeve Howard E · Minot, NDN6650KMiners Inn LLC · Portland, ORN665CBAlquist Kevin B · Edwardsville, KSN6684KMaslar Joseph P · Houston, TXN66CBAlaska Aviation Museum · Anchorage, AKN6706KDornier 27 Warbird LLC · Chugiak, AKN6713KOberholtzer John F · Davis, CAN6724KSteria Kermit J · Monahans, TXN6738KSandy George T · Tehachapi, CAFirst renewal noticeN6739KHendrix Todd M · Bakersfield, CAN6748KWolf Aerospace Corp · Ontario, CA
Back to AD 47-21-21