AD 2022-06-13
Registered aircraft · 180
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-06-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-06-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-06-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-06-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.
N485ECPitt County Memorial Hospital Inc · Greenville, NCN485LFGeisinger Medical Center · Danville, PAN487LFGeisinger Medical Center · Danville, PAN488LFSt Lukes University Health Network · Danville, PAN48SEPhi Health LLC · Tempe, AZN491HCBank Of Utah Trustee · Salt Lake City, UTN492HCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN507MECenter For Emergency Medicine Of Western Pa · West Mifflin, PAN509CHChildrens Hospital Colorado · Aurora, CON522MECenter For Emergency Medicine Of Western Pa · West Mifflin, PAN523ECPitt County Memorial Hospital Inc · Greenville, NCN529MDFlight For Life Inc · Waukesha, WIN542AEAirbus Helicopters Inc · Grand Prairie, TXN545DUMetro Aviation Inc · Shreveport, LAN545KFAir Methods LLC · Greenwood Village, CON55UVRector And Visitors Of The Uva Obo Medical Ctr · Charlottesville, VAN575LFWest Penn Allegheny Foundation LLC · Pittsburgh, PAN578AMAir Methods LLC · Greenwood Village, CON585CHAir Methods LLC · Greenwood Village, CON587MHAir Methods LLC · Greenwood Village, CON592ACMetro Aviation Inc · Shreveport, LAN602MMTrustees Of The University Of Pennsylvania · Philadelphia, PAN605AVAvera Mckennan · Sioux Falls, SDN607SPNew Mexico State Police Aircraft Section · Santa Fe, NMN608UWMetro Aviation Inc · Shreveport, LAN611SJAspirus Wausau Hospital Inc DBA · Wausau, WIN618GLGundersen Lutheran Medical Center Inc · La Crosse, WIN619GESan Diego Gas & Electric Co · San Diego, CAN61UPTrustees Of The University Of Pennsylvania · Philadelphia, PAN624ECPitt County Memorial Hospital Inc · Greenville, NCN635TJAir Methods LLC · Greenwood Village, CON648BHFlight For Life Inc · Waukesha, WIN676LFWest Penn Allegheny Foundation LLC · Pittsburgh, PAN695HSMocha LLC · Tucson, AZN702LFLonian Raven LLC · Wilmington, DEN745TXMother Frances Hospital Regional Health Care Ctr · Tempe, AZN759BHAir Methods LLC · Greenwood Village, CON766MEAir Methods LLC · Greenwood Village, CON770WSMetro Aviation Inc · Shreveport, LAN779LFAir Methods LLC · Greenwood Village, CON78NCAir Methods LLC · Greenwood Village, CON814LVAir Methods LLC · Greenwood Village, CON816ECPitt County Memorial Hospital · Greenville, NCN824EHMetro Aviation Inc · Shreveport, LAN843LFLife Flight Network LLC · Aurora, ORN84UCUc Health LLC · Cincinnati, OHN850UWMetro Aviation Inc · Shreveport, LAN854ECPitt County Memorial Hospital Inc · Greenville, NCN874BUMetro Aviation Inc · Shreveport, LAN87MECenter For Emergency Medicine Of Western Pa · West Mifflin, PA
Back to AD 2022-06-13