AD 2011-10-13
Registered aircraft · 266
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:2011-10-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:2011-10-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:2011-10-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:2011-10-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.
N101DAFlying High Again LLC · Mount Juliet, TNN101SWSkywarrior Flight Training LLC · Pensacola, FLN107NGMccarren Aviation LLC · Green Bay, WIN108LUMidwest Corporate Air Inc · Bellefontaine, OHN108NGRockhill Aerospace Inc · Molino, FLN112NGWestern United Aviation LLC · Yacolt, WAN119BJFlight Stars Az LLC · Tempe, AZN126NGFjr Consulting Inc · Reno, NVN127USN127us LLC · Merrimack, NHN132TSUtah State University · Logan, UTN135DAStella Gem LLC · Belmont, CAN141DACinden LLC · Nashua, NHN142GSFort Wayne Aircraft LLC · Fort Wayne, INN142NGFive Star Marketing Inc · Raleigh, NCN147TSTreacy Jonathan T · Oxford, MEN149WTVectors To Final LLC · Columbus, OHN151MABridgewater State University · New Bedford, MAN153TSAirplane Holding LLC · Huntington Station, NYN158TSMidwest Corporate Air Inc · Bellefontine, OHN168PFJetnexa Eleven LLC · Gilbert, AZN16ESMeow Meow LLC · Seattle, WAN16FAAv8 Flight Assets LLC · Eden Prairie, MNN176TSOld Glory Inc · Tulsa, OKN181CWDiamond 42 N123 Magic Carpet Inc Trustee · Wilmington, DEN1836TAndromeda Air LLC · Houston, TXN188KUOak Street Properties LLC · Pratt, KSN189YCerrit LLC · Helena, MTN190TMN190tm Inc Trustee · Wilmington, DEN1926EEmbry Riddle Aeronautical Univ Inc · Prescott, AZN197TSTango Charlie Foxtrot LLC · Port Orange, FLN198TSWorld Class Aviation Ltd · Bellefontaine, OHN199TSWind Rising Ventures LLC · Columbus, MSN19TSPremier Aircraft Sales Inc · Fort Lauderdale, FLN1PPLevel One Trauma Pllc · Sherman, TXN212SADiamond Aircraft Sales U S A Inc · London OntarioN213WJDiamond N213wj Inc · Coral Gables, FLN215BNMidwest Corporate Air Inc · Bellefontaine, OHN226DSDelta State University · Cleveland, MSN227SKAlf Ix LLC · Chicago, ILN228USAircraft Guaranty Corp Trustee · Oklahoma City, OKN230PASl Aviation LLC · Lakeville, MNN233AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZN234LMRegistered aircraftN236TSFisher Curtis R · Mankato, MNN237TT42.Ac037 Inc Trustee · Wilmington, DEN238USMeow Meow LLC · Seattle, WAN240TSUtah State University · Logan, UTN242BLTake Flight Aviation LLC · Montgomery, NYN242DPFlying High Again LLC · Mount Juliet, TNN243TSJoerithan & Mp Aviation LLC · Whittier, CA
Back to AD 2011-10-13