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.
N770ALAviation Company Inc · Cheyenne, WYN770DSSpirit Of America Foundation Inc · Chattanooga, TNN772CSH & D Aviation LLC · Smithfield, NCN772SBApex Air LLC · Dover, DEN773RBPymp LLC · Nashville, TNN774SBAirmed International LLC · Birmingham, ALN775SCZw Air LLC · Little Rock, ARN776GMGlobus Aviation LLC · Audubon, PAFirst renewal noticeN776WRTwin Eagles Aviation Inc · Fort Mohave, AZN777AQBcms Investments LLC · Dexter, MON777AWFair Air Aviation LLC · Myrtle Beach, SCN777AXJc Investors Group LLC · Coral Springs, FLN777CJHarvest International Ministries Inc · Texarkana, ARN777MXAirplane III LLC · Fulshear, TXN777SSCalderwood Aviation LLC · Shafter, CAN777WYGulf Atlantic Airways Inc · Gainesville, FLN777XPRbwdb Aircraft LLC · Lufkin, TXN778BValiair Lc Trustee · Casper, WYN778TBTrcc Inc · Visalia, CAN779RKMcaire LLC · Newton, NCN77CA77ca Associates LLC · Coral Gables, FLN77HFCb Aircraft Inc · Fort Lauderdale, FLN77LXWatford Horizons LLC · College Station, TXN77MAM Aire LLC · Wilmington, DEN77PRTrns Solutions LLC · Lewes, DEN77SFSeneca Foods Corp · Penn Yan, NYN78Federal Aviation Administration · Oklahoma City, OKN780CBQuality Liquid Feeds Inc · Dodgeville, WIN780CFAlcyone Trust Corporation Trustee · Wichita, KSN782STBlue Skies Aviation Of Daytona Inc · Ormond Beach, FLFirst renewal noticeN785CWConstruction Solutions & Consulting LLC · Sedalia, MON785WCWillwork 4 Jeta LLC · Houston, TXN7867THoldsworth David · Crystal City, TXN786MXMadix Inc · Terrell, TXN787CVRowley Aviation Inc · Fort Lauderdale, FLN789CTKingfisher Associates LLC · Wilmington, DEN789JKJk Aircraft Options LLC · Aripeka, FLN789JSArs Air LLC · Newport Beach, CAN78MDValiar Ltd Co Trustee · Casper, WYN79Federal Aviation Administration · Oklahoma City, OKN790ALAngels Envy Aviation LLC · Denison, TXN791EBSav Aviation LLC · Jacksonville, TXN793BCFour Lee LLC · Jeffersonville, INN795JKN90tr LLC · Paso Robles, CAN795PAPdx LLC · Indianapolis, INN796MACypress Aircraft Sales LLC · Clermont, FLN797MMNext Generation Aviation LLC · Beloit, WIN797TEN797te LLC · Hermiston, ORN798JSLtn Aviation LLC · Draper, UTN799ALDelt Holdings Orange LLC · Dubuque, IA
Back to AD 90-06-13