AD 2022-08-13
Registered aircraft · 3,069
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:2022-08-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:2022-08-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:2022-08-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:2022-08-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.
N125ZUsda Forest Service · Boise, IDN12666Wdr Inc · Grand Forks, NDN126HBKansas Farm And Ranch Inc · Seneca, KSN126JHM&P Aviation LLC · Lakeland, TNN126RFRandigo LLC · Wilmington, DEN1276YJet Rider LLC · Middletown, DEN127ARAircraft Unlimited Inc · Pierre, SDN127AXAlaska Central Express Inc · Anchorage, AKN127GABeech Transportation Inc · Eden Prairie, MNN127RFRandigo LLC · Wilmington, DEN12813Razor Aviation Corp · Kalispell, MTN128SFWin Win Aviation Inc · Wake Forest, NCN128STJet Rider LLC · Middletown, DEN128WWSpears Aerial Crop Care LLC · Mamou, LAN1296STvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN1296YPa1 208b-1079 LLC · Fort Lauderdale, FLN129CGSchuman Carriage Co Ltd · Honolulu, HIN129EJShelbyville Auto Sales LLC · Shelbyville, TNN129JWAir Methods LLC · Greenwood Village, CON129LABluebird 2000 LLC · Wilmington, DEN129LCL R & F LLC · Dover, DEN129TPHljh LLC · Corpus Christi, TXN12FAWilke Aviation Group LLC · College Station, TXN12GJBuilding Ideas Inc · Los Gatos, CAN12LUDonalds Flying Service Inc · Pantego, NCN12MNMinnesota Department Of Transportation · Saint Paul, MNN12XVStormhaul Holding LLC · Taylors, SCN1314XWright Air Service Inc · Fairbanks, AKN131GPUas Transervices Inc · Boca Raton, FLN131RFRandigo LLC · Wilmington, DEN131SAPiper Aircraft Inc · Vero Beach, FLN131SJGravitas Aviation LLC · Dallas, TXN131SPKauffman Land & Development LLC · Denver, CON1322TStrain Aviation LLC · Arbuckle, CAN1323YState Of Alaska · Anchorage, AKN1324GProps & Jets Inc · Dover, DEN132KCAlpine Aviation Inc · Provo, UTN132TJVertol Systems Company Inc · Destin, FLN133GAJab Aire LLC · Wilmington, DEN133KQValiair Lc Trustee · Casper, WYN133RFRandigo LLC · Wilmington, DEN134ME D Santos & Associates LLC Trustee · Wilmington, DEN1350AAlaska Skypower LLC · Fairbanks, AKN135CKStellar Aviation LLC · Williamstown, NJN135FLAfdflt LLC · Mount Vernon, ILN135LTFleming William D · Litchfield, ILN135RFRandigo LLC · Wilmington, DEN13642Visser Ag Inc · Rigby, IDN136CLAircraft Structures International Corp · Enid, OKN1375FBank Of Utah Trustee · Salt Lake City, UT
Back to AD 2022-08-13