AD 2016-22-10
Registered aircraft · 363
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:2016-22-10')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-22-10')
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:2016-22-10') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-22-10') 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.
N498AEPhi Health LLC · Tempe, AZN503PHCity Of Miami Police Department · Miami, FLN507MECenter For Emergency Medicine Of Western Pa · West Mifflin, PAN509CHChildrens Hospital Colorado · Aurora, CON511SCSabercat Productions LLC · Scottsdale, AZN522MECenter For Emergency Medicine Of Western Pa · West Mifflin, PAN522SCSouth Coast Helicopters LLC · Fullerton, CAN523ECPitt County Memorial Hospital Inc · Greenville, NCN529MDFlight For Life Inc · Waukesha, WIN542AEAirbus Helicopters Inc · Grand Prairie, TXN543MMHappyheight Inc · El Monte, CAN545DUMetro Aviation Inc · Shreveport, LAN545KFAir Methods LLC · Greenwood Village, CON547AMTrevor Corp DBA · Grayslake, ILN547SAShier Aviation Corp DBA · San Diego, CAN548GBAviation Instrument Services Inc · Miami, FLN557CBChaparral Air Group · Grapevine, TXN568AMEurotec Vertical Flight Solutions LLC · Eudora, KSN573AMIsland Air LLC · Westbury, NYN575LFWest Penn Allegheny Foundation LLC · Pittsburgh, PAN576AMAris Aviation Group LLC · Henderson, NVN576VPN576vp LLC · Chino, CAN578AMAir Methods LLC · Greenwood Village, CON5805TStefenelli Aviation N-Tr Inc Trustee · AtterseeN5854ZPuerto Rico Electric Power Authority · Carolina, PRN5855ZPuerto Rico Electric Power Authority · San Juan, PRN585AEPhi Health LLC · Tempe, AZN585CHAir Methods LLC · Greenwood Village, CON590AEPhi Health LLC · Tempe, AZN592ACMetro Aviation Inc · Shreveport, LAN596WAFleet Unlimited Inc · Pasadena, CAN602MMTrustees Of The University Of Pennsylvania · Philadelphia, PAN6080RTemsco Helicopters Inc · Ketchikan, AKN608UWMetro Aviation Inc · Shreveport, LAN6094ETemsco Helicopters Inc · Ketchikan, AKN6094UTemsco Helicopters Inc · Ketchikan, AKN609TXCopters In Agriculture Llp · Sonora, TXN60TXTexas Department Of Public Safety · Austin, TXN611LLIntegrity Aircraft Title Holdings LLC · Portland, ORN611SJAspirus Wausau Hospital Inc DBA · Wausau, WIN611TCAircraft Trustee Services Inc Trustee · Dover, DEN614ADEurotec Vertical Flight Solutions LLC · Eudora, KSN618GLGundersen Lutheran Medical Center Inc · La Crosse, WIN61CVState Of Montana Dept Of Fish Wildlife & Parks · Helena, MTFirst renewal noticeN61UPTrustees Of The University Of Pennsylvania · Philadelphia, PAN624ECPitt County Memorial Hospital Inc · Greenville, NCN624KSAerial Coalition Surveillance LLC · Winnie, TXN632SDCounty Of Oakland · Oakland, MIN635TJAir Methods LLC · Greenwood Village, CON644LHBank Of Utah Trustee · Salt Lake City, UT
Back to AD 2016-22-10