AD 2011-20-01
Registered aircraft · 677
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-20-01')
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-20-01')
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-20-01') 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-20-01') 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.
N312QSRegistered aircraftN314FXFlexjet LLC · Cleveland, OHN314QSRegistered aircraftN315FXEmbraer Executive Aircraft Inc · Melbourne, FLN315LDOcean View Aviation LLC · Aventura, FLN316QSRegistered aircraftN317NNicholas Services LLC · Oxford, MSN318DTN4195s LLC · Little Rock, ARN318QSRegistered aircraftN319QSRegistered aircraftN31SSDd Voyage LLC · Wilmington, DEN322FLPyng LLC · Palo Alto, CAN322LLRicalichan LLC · Los Gatos, CAN322QSRegistered aircraftN323GGMitchell Development Group LLC · Great Falls, MTN323KPGp Air Services Inc · Houston, TXN324ASExecutive Airshare LLC · Lenexa, KSN324CXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN324FLProvident Realty Advisors Inc · Dallas, TXN325ASExecutive Airshare LLC · Lenexa, KSN325QSRegistered aircraftN326ASExecutive Airshare LLC · Lenexa, KSN326EEBank Of Utah Trustee · Salt Lake City, UTN326QSRegistered aircraftN327MCMrk LLC · Belgrade, MTN327QSRegistered aircraftN327SCEhc Holdings V LLC · Birmingham, MIN328QSRegistered aircraftN329MCAced Aviation LLC · Saint Petersburg, FLN32KCF & S LLC · Jefferson City, MON32MKh Partnership LLC · Whitefish, MTN32ZWRodforce 1 LLC · Omaha, NEN330QMaxair LLC · Appleton, WIN330QSRegistered aircraftN331ASExecutive Airshare LLC · Lenexa, KSN331FXFlexjet LLC · Cleveland, OHN331GVWheels Up Partners LLC · New York, NYN331QSRegistered aircraftN332EEBank Of Utah Trustee · Salt Lake City, UTN332QSRegistered aircraftN333FXFlexjet LLC · Cleveland, OHN333KZWarrior Notes · Destrehan, LAN333QSRegistered aircraftN335ASExecutive Airshare LLC · Lenexa, KSN335QSRegistered aircraftN336QSRegistered aircraftN337ASExecutive Airshare LLC · Lenexa, KSN337QSRegistered aircraftN340ASExecutive Airshare LLC · Lenexa, KSN340GVLe Air II LLC · Lafayette, LA
Back to AD 2011-20-01