AD 2012-21-05
Registered aircraft · 186
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:2012-21-05')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-21-05')
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:2012-21-05') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-21-05') 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.
N2971Dick Holdings LLC · Merritt Island, FLN321WVHill Stephen D · Lincoln, NEN324EAWaytack LLC · Bryant, ARN325JWKlug Transport Inc · Farmington, MON341EEggleston William Joseph III · Leakey, TXN34BPAviation Insurance Managers Inc · Uniontown, OHN358RMMrm Phoenix Ltd · Cape Girardeau, MON36JGJones Aviation LLC · Danville, CAN3730YSilversky Exploration LLC · San Antonio, TXN384BCCrider Transportation LLC · Stillmore, GAFirst renewal noticeN391BRWagers Wings LLC · Cleveland Heights, OHN39KTEcojiva Air LLC · Bloomfield Hills, MIN412GHHavemeier Gregory Wiliam · Marco Island, FLN429MAirmart Inc · Lexington, KYN430GLFogle LLC · Bella Vista, ARN432ZBaronhawks LLC · Jacksonville, FLN440BETextron Aviation Inc · Wichita, KSN444KY444 Dd LLC · Chavies, KYN453BBBass Equipment LLC · Texarkana, ARN458GShasta Air LLC · Sacramento, CAN464EABaron Four LLC · Virginia Beach, VAN47PHReal Time Aviation LLC · Southlake, TXN47WK57 Bw LLC · Reno, NVN48MWFour Echo X-Ray LLC · Boston, MAN495AUCohen Aircraft Leasing & Sales LLC · Dunwoody, GAN500KBKilo Bravo LLC · Mount Airy, MDN5026AMartin Kent D · Pittsburg, TXN5036UTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN504WEArchitectural Supplements Aviation LLC · Waterbury, CTN5070JCrc Properties Inc · Coto Laurel, PRN50LPParker-Long LLC · Lexington, NCN513KXHart Aviation Enterprises LLC · Jonesboro, ARN517MPMorey Organization Inc · Wildwood, NJN517RBRbc Holdings LLC · San Juan, PRN51HAJd Air Inc · Fairlawn, NJN521JCRasmussen Group · Des Moines, IAN522RBWahoo Aviation Inc · Charlotte, NCN523BOhh Cat Inc · Oklahoma City, OKN525Alpine Aviation LLC · Oklahoma City, OKN529LHRightway Drywall Inc · Macon, GAN533PMMccollom Perry C · Saint Louis, MON538BBTextron Aviation Inc · Wichita, KSN53VEReam Aviation LLC · York, PAN549RSN549 Romeo Sierra LLC · Wilson, NCN553WETextron Aviation Inc · Wichita, KSN577HRBonanza Holdings LLC · Rapid City, SDN580CXWicked Wings Aviation LLC · Dover, DEN580SMMacair Leasing LLC · Cocoa, FLN584DWAviation Trust Company LLC Trustee · Oklahoma City, OKN584PCHurry Back Air LLC · Knoxville, TN
Back to AD 2012-21-05