AD 90-06-13
Registered aircraft · 1,827
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:90-06-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-13')
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:90-06-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-13') 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.
N870BTdc Transportation LLC · Sylvania, OHN872JPJssi Parts LLC · Chicago, ILN875SPPacific Mission Aviation · Hagatna, GUN876ATTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN876BBKc & Sc LLC · Forest, VAN876JATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN877KBBank Of Utah Trustee · Salt Lake City, UTN878CHBruce Alexander Company LLC · Elkhart, INN879TYKimmel Aviation LLC · Madison, MSN87BAUc Aviation Holdings LLC · Union City, TNN87SFSeneca Foods Corp · Penn Yan, NYN87SNB & M Aviation LLC · Theodore, ALN880PSVientos Air LLC · Santa Fe, NMN881SJEdwards Pacific Aviation Corp · Dover, DEN882RBGainesville Aircraft Sales Inc · Gainesville, FLN882WFSotex II LLC · Midland, TXN883TXWhitehorse LLC · Puyallup, WAN884EATvpx Ars Inc Trustee · North Salt Lake, UTN884RCJannenga Air LLC · Phoenix, AZN886AWAndrew & Williamson Sales Co · San Diego, CAN886YSTs Sky LLC · Sellersburg, INN888ASStanislaus Food Products Co · Modesto, CAN888ETBank Of Utah Trustee · Salt Lake City, UTN888FGTv Brothers LLC · Houston, TXN888GDCluheir LLC · Van, TXN888HJAviation Company Inc · Cheyenne, WYN888RLRegistered aircraftN888WDEagles Wings Holdings II LLC · Canfield, OHN888XKDodson International Parts Inc · Rantoul, KSN888XLStafford Mark K · Prineville, ORN889CP1khomes LLC · Asheville, NCN88AJMarathon Merchant LLC · Waukesha, WIN88MTFlight Company LLC · Rome, GAN88NWWnd Aircraft Management LLC · Miami, FLN891EATvpx Ars Inc Trustee · North Salt Lake, UTN891FVSuper King LLC · Wilmington, DEN891KSParr Aviation LLC · Demopolis, ALN891SHHulfe Air LLC · Caguas, PRN894NTTeam Aero LLC · Olathe, KSN896CGJet Services Inc · Mobile, ALN896CMXrp Investments LLC · Clyde, MIN896MAQ-Sky LLC · Fairhope, ALN898LGGold Penny Aviation LLC · Stayton, ORN898SLMurphy Air LLC · Pine Bluff, ARN899BEcho Romeo Aviation LLC · Dallas, TXN899PEArkansas Jet Sales & Leasing LLC · Little Rock, ARN899SDRed Rock Aviation LLC · Dover, DEN89DSowela Technical Community College · Lake Charles, LAN89GAWno Trust Services LLC Trustee · Wilmington, DEN89MDFuturesource Capital Corp · Bismarck, ND
Back to AD 90-06-13